How do I write a macro in XL that will delete 1st row and save th.
 

I would like to create a macro that deletes the the first row or the first
two rows and saves the file with a new predefined name and location.

How do I write a macro in XL that will delete 1st row and save th.
 

With Activeworkbook
.Worksheets("Sheet1").Rows("1:2").Delete
.SaveAs Filename:= myFile
End With

where myFile is the predefined name.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nitin" wrote in message
...
I would like to create a macro that deletes the the first row or the first
two rows and saves the file with a new predefined name and location.