I would like to export my SAVES worksheet to a new spreadsheet.  I would
like to copy only Cells A25 to ZT65536.
Path to new spreadsheet is: C:\Temp
File Name is: SAVES.csv

Dim Cnt As Integer
I'm try to insert 5 new rows, then copy the previous row down thru the next
5 rows. I'm have some problem in getting it to work. Need help.
Thanks

hi,
i have the following:
dim x as integer
for x = 1 to lastcol

I found this code online from Microsoft that automatically changes a formula
to an ISERROR formula using your original formula...
http://support.microsoft.com/kb/213387
It works awesome, but it only does one cell at a time. I have been trying,

I have a macro which I have recorded and does everything I need it to
except changing the page setup infromation. I receive no errors but it
does not even put the header or change the orientation, Any help would
be much appreciated.

I have a file lets name it file One Xl Sheet that has  10 Colums and Another
file two one that has 50
I would liketo rearrange  the file one colums  in such an order to match the
order in file B. So for example input

I have a workwheet that is using a lookup table.  Everything works fine
except when I update (change) the data in the lookup table.  I have confirmed
the location of the lookup table but just does not want to update the data in
the worksheet.  

I have 2 worksheets, "Sheet 1" and "Sheet 2".  First, my code checks the
length of Cell "E26" in "Sheet 1".  If the length of E26 is not equal to 6,
delete the records (entire row) in "Sheet 2" with the values "A-1", "B-1" and
"C-1" in column F of Sheet 2.  Then move the records ...

Hi, I want to automate a simple task but know nothing about Excel macro
programming.  The macro recorder doesn't do what I want so I guess I need to
write something.
I'd like to perform the following steps in a macro:

Could someone point me in the right direction for how to resize a
worksheet. I have a macro that deletes a lot of rows. After is
finishes, I want to hit "ctrl+A" but it grabs the original number of
uses cells. Make Sense?

I want to open a MS Project file and create a list of the Task table field
names. (e.g. ID, Name, Start, Finish, etc.) I want the complete list of field
names to populate to an Excel worksheet.
I am looking for code to do two things:

Hi Excel Gurus.
I would like to make a dynamic graph-plot - the dynamic part consists
of buttons next to the graph plot, where you can turn certain plots
"on and off".

I used this little trick in the office for a few recent projects:
http://www.j-walk.com/ss/excel/tips/tip94.htm
It works perfectly fine on the machines in the office, with the exception of
one machine.  As far as I can tell, we have all the MS critical updates for

How can I filter a protected shared worksheet?
1. I have allowed filtering in protection & can filter the protected
worksheet manually but if I try using code it says its protected. Code used
to filter Selection.AutoFilter Field:=3, Criteria1:="LK"

I right now copy a sheet inside a "Variant" matrix using a command like
   sheet.Cells(y,x) = matrix(y,x)
and back
   matrix(y,x) = sheet.Cells(y,x)