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.
|