End of range help on macro

[johnlynches]

I'm trying to insert a formula starting at H2 and go to the end of my range of data, but I'm not sure how to do that. I keep getting errors whenever I try something. Here is what I have tried:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Please let me know what I am missing. Thanks.

[Richard Buttrey]

Hi,

Range("H2").Copy Destination:= Range("H3:H" & Range("H" &Rows.Count).End(xlUp).Row)

Regards

[johnlynches]

I pasted this new code in, but only H2 gets the correct forumla in it. H3 gets an incorrect formula, and all other cells below that are blank.

Please Login or Register  to view this content.

[johnlynches]

Do you know how I would edit this to apply to my entire range of data as well?

Please Login or Register  to view this content.

Thanks.

[johnlynches]

I fixed the issue. In the Range("H" & Rows.Count).End(xlUp).Row) the column H was empty so I had to choose a different column. Thanks