HI.

I am running a fill down macro and am needing some assistance....

How do I word the macro so that it goes down to a particular row?
(instead of searching a range or column).

I.e. - I need one of these to say the last row is always 500.



Set LastRow = Sheet1.Range("a65536").End(xlUp)
or
LastRow = Range("a65536:hc65536").End(xlUp).Row



Thanx