Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to automate with macro multiworksheet File using array variable?
I created a file with multiple Worksheets and defined an Array:
Dim arrRtTab(1 To 12) As String arrRtTab(1) = "MS" arrRtTab(2) = "MW" arrRtTab(3) = "MM" arrRtTab(4) = "MU" arrRtTab(5) = "MDS3" arrRtTab(6) = "XS" arrRtTab(7) = "XN" arrRtTab(8) = "QN" arrRtTab(9) = "QE" arrRtTab(10) = "QS" arrRtTab(11) = "NS" arrRtTab(12) = "LI" How can I access tabs of the file as variables for copy and paste operation in my macro? I need to copy from tab "LI" to tab"MS" or another tab pending results of other computations. Georgee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to automate excel file sending by outlook from within the file | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
open file (as variable) from macro | Excel Discussion (Misc queries) | |||
Problem trying to us a range variable as an array variable | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |