Save As, Select, Delete in Macro Recorder or VBA

[Rick93636]

Using either Macro Recorder or VBA I need to:

Save As

Select Rows

Delete Selection

Select Cell

Delete Selection

Save

Thanks,

Rick

 

[Kamolga]

expression.saveas

Rows(1).select

Selection.delete

Range("A1").select

.save


But simple Go on développer tab (file/option/ribbon if you do not Sée IT already), click record macro and male those action. Hou then click macro, Go on edit and Read the codes (or run it for reproduction)

 

[Rick93636]

Thanks! I didn't realize I could use mouse actions when recording a macro. It works great.