Refrencing Diffrent Tab.
 

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

Refrencing Diffrent Tab.
 

You want the lastrow based on column A of a different worksheet, but you want to
fill the activesheet from A3 to that lastrow?????

With worksheets("Sheet9999")
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
End With

With ActiveSheet
.Range("A3:A44").AutoFill Destination:=.Range("A3:A" & LastRow), _
Type:=xlFillDefault
End With

Ardy wrote:

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

--

Dave Peterson