I am trying to use the value in a cell in a calculation.  But I want the
results of the calculation to stay in the cell.
Here is my formula: =ROUND(D1*ActiveCell.Value,2).  The active cell contains
the value 0.1017.

I am importing data from a lot of .xls files(over 100).  The data
imports and goes to the apprioriate location.  The problem I am
encountering is that I get blank rows.  My spreadsheet will look
similar to this

I have a fairly complex spreadsheet that requires salespeople to fill in
info.  Many cells are locked from being changed.  Is there a way to create a
macro that looks a current sheet and will change the cell color if cell is
locked (or unlocked)?  Right now I review by going from ...

I'm using this code to copy and paste 3 character or less names to a sheet in
the workbook called "Short Name".  This code picks up names that are in the
column D like "Lee, Barbara" or "Ray, Joyce".  The problem is sometimes the
names display with a space before the comma, like ...

I have one workbook that copies information to another workbook.  What
was wondering is:  how can I update the already copied information i
needed?
Would I need a userform?

Someone hid about 50 sheets in a workbook.  What would be the code to unhide
them all without doing it one by one from the Format menu?
Thank you
Marco

Given the following code posted by Kaak, how would I copy data from
different places in this 500 Byte record to different cells in the
spreadsheet.  The file I am working with may have up to 1000 records in it
each day, and each record is 500 bytes.  I was thinking that ...

How do I go from:
1 to one
2 to two
etc.etc. all tyhe way up to 200, grateful for any hel

When macros are running is there any way in which you can pause them,
save and resume?
Thanks.

I am trying to sum col L on Data Sheet if Col A on Sales Reps matches Col K
on Data Sheet.. I have attempted it below but i failed. Any help?
[CODE]
 With Range("L2:L5000")

I need some help with a macro I am creating.  I have the following code
to create an email
Code:
--------------------

While I am editing a cell's formula, I would like to be able to select
an autoshape (in the same way that one selects a range) and somehow
have the name of that autoshape be inserted into the formula, just like
a selected range.

I need to print a userform that I created.
I've tried using the Userform.Printform statement but it prints to the last
printer that I used.
Is there any way to get the printing preferences box to come up so that I

OK, so heres one for you all, I have an indicator cell with conditional
formatting, so depending on other conditions it is red, amber or green.
I also have a button that runs a macro, if you click this button when
the cell is red, I need an error message to come up with something ...

I need some help with the following: I have a (dynamic) range called
rangetest. I want to show some data in a userform, with buttons "next" and
"previous". But I don't now how to count the rows in my range (see the code
below).