T
T De Villiers
My current code isnt quite working.
I am trying to get A Range of cells from Row 1 in current sheet into
Column A in "TS Total" Worksheet, the actula range differs, depending
on values of firstcol and lastcol.
Here lastcol = 20 and firstcol = 10
Sheets("Weekly").Select
Sheets.Add.Name = "TS TOTAL"
For i = firstcol + 1 To lastcol - 1 Step 1
Cells(1, i) = Worksheets("TS TOTAL").Cells(i, 1)
Next
Many Thanks
I am trying to get A Range of cells from Row 1 in current sheet into
Column A in "TS Total" Worksheet, the actula range differs, depending
on values of firstcol and lastcol.
Here lastcol = 20 and firstcol = 10
Sheets("Weekly").Select
Sheets.Add.Name = "TS TOTAL"
For i = firstcol + 1 To lastcol - 1 Step 1
Cells(1, i) = Worksheets("TS TOTAL").Cells(i, 1)
Next
Many Thanks