Range definition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to define a range "Selection.AutoFill
Destination:=Range("M5:T???")" Where T???? changes depending upon how much
data (# of filled Rows) is in column "A". I have used several methods to
determine how much data is in Column "A" but I can not figure out how to put
that number back into the Range statement.

Hope this makes sense!

Thanks for your help!
 
Try something like this...

Destination:=Range("M5:T" & Cells(Rows.Count, "A").End(xlUp).Row)
 
Jim,

Thank you! I ended up with somthing similar, but since I am using the # of
Rows in several subs I made it a variable.
 
You must log in or register to reply here.

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

Selection.AutoFill Destination:=Range 0
I have to run macro twice to work? Why 6
Autofill range 2
Excel VBA 1
Problem Applying Formula to cell 2
Autofill with Column as a variable 5
Post my named ranges in column A 10
Add row dynamically 15

Back
Top