Kinda confused. You just want the last row to always be 500? The
just substitute "500" for wherever you are using the LastRow
variable. Now, I could be completely misunderstanding your
perdicament.

J.W. Aldridge wrote:
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