Hi, I have a macro that selects an entire column based on an input box.
I would like to change it so that it selects the entire column based on the value of 1 cell. ie ( Set up tab, cell A1). And then select that column for every worksheet in my workbook ( there's like 20 ). I appreciate any help. thanks.![]()
Macro2 Macro ' Dim UserReply1 As String UserReply1 = InputBox("Enter column letter to hard code") Columns(UserReply1 & ":" & UserReply1).Select Selection.Copy
Bookmarks