| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro with Range of Worksheets
This is probably simple to do, but I don't do this enough to know.
How would I edit this macro to paste to a range of 134 worksheets that are after two that I do not want to paste to. In this example I have gone to each worksheet and pasted one at a time. Range("G14").Select Selection.Copy Sheets("2").Select Range("G14").Select ActiveSheet.Paste Sheets("3").Select Range("G14").Select ActiveSheet.Paste Sheets("4").Select Range("G14").Select ActiveSheet.Paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro does not run when data refreshed | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
| Macro for Show/Hide Range | Excel Discussion (Misc queries) | |||
Threaded Mode
