Range definition
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.
--
I am not where I intended to go, but I think I am where I am supposed to be!
"Jim Thomlinson" wrote:
Try something like this...
Destination:=Range("M5:T" & Cells(Rows.Count, "A").End(xlUp).Row)
--
HTH...
Jim Thomlinson
"thewizz" wrote:
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!
--
I am not where I intended to go, but I think I am where I am supposed to be!
|