Range.FillDown Acting Weird??

[Raysoc]

I use the following code:
Range(Cells(3, 26), Cells(lr, 26)).FillDown

Which works fine UNLESS lr=3 then for somereason it fills from 1,26 to 3,26 which is def not what I want....

Sometimes the sheet doesnt have any data.. so it doesnt need to fill down, so is there a better way to fill down or should I just add in a check on 4,26 for null if so dont fill?

Thanks!

 

[Tom Urtis]

If lr > 3 then Range(Cells(3, 26), Cells(lr, 26)).FillDown

 

[VoG]

Try

If LR > 3 Then Range(Cells(3, 26), Cells(LR, 26)).FillDown