Refrencing Diffrent Tab.

  • Thread starter Thread starter Ardy
  • Start date Start date
A

Ardy

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
 
don't see how this will work
.Range("A3:A44").AutoFill Destination:=.Range("A3:A" & LastRow), _
Type:=xlFillDefault

maybe
.Range("A3:A3").AutoFill Destination:=.Range("A3:A" & LastRow), _
Type:=xlFillDefault

but i'm not sure what you're trying to copy where
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error on Autofill 2
Run two macros for two different sheets 11
Row spec 4
Transfering Info Stop When Null 1
Macro will copy formula instead of value 6
Error Auto Fill Method of Range Class Failed 1
Copy to row xx 5
save a range to copy for later 2

Back
Top