Within a macro I have a "found" cell (Find "US03" in certain column) which
can be on any row.  I need code to count down 170 rows from this cell and
insert 2 rows. This is done from the top of the worksheet.
Thanks!!

When I've protected VBA with a password, and I want to save my workbook as
an Excel 97/2000 workbook, I get an error message that's saying that I must
"unprotect" the VBA-code before saving the workbook. I've written the code
with excel 2003.

I have a VBA program that uses both "PasteSpecial" and "Paste" Methods.
I have no problem using the "PasteSpecial" Method as follows:
   Sheets("Val").Range("BE19:BE66").Copy
   Set MyRangePaste = Sheets("Save_Scen").Range("H124")

Hi Id like to copy some data from one open workbook to another open
workbook using vba. Date in first workbook is in sheet1 a1:m1000. Id
like to copy this to sheet1 in the second workbook. Any ideas please
Regards Robert

"How do I set the total number of elements of an array  to match the total
number of items in a ComboBox
thanks in advance"

How do I tweak the following code to cut and paste all rows with "deal" or
"no deal" in column A rather than "S".  Here is my code.
Thanks
Sub MoveStuff()

I've searched through the Excel "Help" structure, the MS KB
and Excel pages as well as google-ing for all the combinations
I could think of to find a method to produce a list of all of the
user *sub*s and *function*s which are contained in an Excel

I have a rollup worksheet and using a macro it gathers all the VOL and
MIN columns from the other worksheets onto the rollup worksheet.  But
I would like to add a GRAND TOTAL VOL and GRAND TOTAL MIN on the
rollup worksheet.

I am using a mail merge and the letters contain fields for gift
amounts.  I am looking for a way to have dollar signs appear in the
fields which have a value greater than zero, but not appear
otherwise.  The data I am pulling has no dollar signs.  So, for

Don’t you count backwards with a for next loop using the following
For i = 1 To 4
Sheet1.Cells(i, 1) = i
Next i

I am using Excel2003 and Vista Premium;
I am trying to position a comment on the left side of a cell,
I edit the comment and then move it to the left side of the cell.
When I re-hover over the cell it is back on the right side

I need to write a macro that will allow me to compare to worksheets to
identify what has been added, deleted, or otherwise edited from one to the
other.
I know how to program the formatting issues to make sure the columns are

I have a spreadsheet which uses the RTD method to get real time data
into my spreadsheet.
I'd like to use VBA to do some calculations on a large number of these
RTD values.

I eager to get some help and am resubmitting this from yesterday...  I have a
macro with about 20 userforms.  As far as I can tell, it worked great in
earlier versions of Excel.  I am now using the macro on a new machine with
Excel 2007.  After I call the exact same sub-routine a ...

I currently have two work sheets in an excel document and I need to create a
chart to read the one sheet and fill in the other sheet with either an "x" or
the mark.
as an example the information is on sheet1 and I need it to read the persons