Is there a way of pausing a macro

S

Shazza

Hi i am trying to record a macro to create a new worksheet and then save it
as the title of that worksheet but i cant get the macro to pause or wait for
me to enter in the file name and it just keeps trying to give the sheet the
same name that i saved it to when i was recording it. Is there a way of
getting it to pause so thta i can enter in the file name before it continues
with the rest of its instructions
 
J

Joel

Add test code to your macro

1) Use an Inputbox so you can type in information
2) add a statement line Myfilename = "c:\temp\testfile.txt"
3) Write test code that writes too cells on the spreadsheet
Range("A3") = "Test Data"
 
Top