Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
|
Re:
alter macro code
I have the macro below recorded for sheet 3, I would like it to run on sheet three through to sheet 369, could anyone enlighten me. Thanks in advance. Sub sort() ' ' sort Macro ' ' Keyboard Shortcut: Ctrl+a ' ActiveWorkbook.Worksheets("Sheet3").sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet3").sort.SortFields.Add Key:=Range("G1:G92") _ , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal With …
|