View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LauraB LauraB is offline
external usenet poster
 
Posts: 9
Default Creating a Macro to autofill and save

Hi,

I am trying to create a macro that will complete the following.

Autofill column K with sequential numbers starting from cell K2 with 1 to
however many rows of data there are.

Then for the file to automatically save as a CSV (Comma Deliminated) format
so that the user just has to typr the name of the file in.


I am not a competent using visual script however should be abl to navigate
myself to the right place.

Thanks
Laura