Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All:
I have this code: With ActiveSheet LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row .Range("A3:A44").AutoFill Destination:=.Range("A3:A" & LastRow), _ Type:=xlFillDefault End With This is for the same tab as the information, how would I modify this to different tab. In LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row. What I want to do is refrence my last row in a different tab. Regards, Ardy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date refrencing | Excel Worksheet Functions | |||
Formular for refrencing two referances | Excel Worksheet Functions | |||
Refrencing Diffrent Tab. | Excel Programming | |||
Refrencing | Excel Programming | |||
Refrencing an entire worksheet? | Excel Discussion (Misc queries) |