Using AutoFill in a macro

[RogerBell]

I have a macro that has the following statement to copy a formula down one column.

Please Login or Register  to view this content.

Instead of only filling to the bottom of the data base, it fills all the way to the bottom of the spread sheet.
How do I correct this?

Thanks for any help!!!!!!

[Dennis7849]

From VBA's help utility,

Please Login or Register  to view this content.