VBA code won't fill down

[kodachrome1]

I'm trying to translate the following code into VBA.

Please Login or Register  to view this content.

I have the following. I'd like to paste the results down to the end of column H, which varies from data run to data run, but the formula only fills in H2. How do I get it to go down to the end?

Please Login or Register  to view this content.

[David A Coop]

Hi Kodachrome1,

Welcome to the forum.

It is always a good idea to post a copy of your workbook. Sanitized, of course, for confidential information.

Having said that, I think I can see your problem!

Your variable Hrow does not appear to be assigned a value. Therefore it will always write to H2. Perhaps you could simply replace Hrow with c.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.