Macro VBA SUB / Module Question

[LNG2013]

Ok so I have several different scripts that I have to basically clean up a file.

1.) Copies the data
2.) Open a new file and pastes it
3.) Renames some columns
4.) Moves some column
5.) Deletes some columns
6.) Creates some columns
7.) Save and close

I have all of this under module1, and it is basically multiple scripts I have pasted together.... Should each be seperated by a SUB?

Sub test ()
End Sub

 

[hiker95]

LNG2013,

Should each be seperated by a SUB?

Can we see your macro code?

If posting VBA code, please use Code Tags, see below in my Signature block: If posting VBA code, please use Code Tags - like this