AutoFill Troubleshooting

(This is part of a much larger macro, I can provide more if necessary)
When I use the following function and Column H is empty below H1, the word TEMP is being copied to cell F1 and overwriting my header. I assume this is because Row 1 is being flagged as my LastRow. When there is data in H2 or below I do not have this bug.

Please Login or Register  to view this content.

How would I go about making it do NOTHING if H2 is empty? I'm thinking an If statement, but I'm yet to do any in VBA. Would this work? H1 is my header, "VIN". (I'm learning!)

Please Login or Register  to view this content.

Why do you want to use Autofill?
And that's not even a formula.
If Column H is your benchmark,
Try:

Please Login or Register  to view this content.

Originally Posted by lelouchevi

Why do you want to use Autofill?
And that's not even a formula.

Haha, I warned I was learning!

AutoFill is what gets generated when I start my macros using the macro recorder; I learn best by picking things apart. I've just recently started using the lastRow functions.

I currently don't have any VINs to process so your formula appeared to work perfectly in that aspect - no more messed up header! I should have new data this afternoon to try when I actually have VINs.

Thank you!

Sorry but it's not entirely correct.

Please Login or Register  to view this content.

This will work even if column H is empty till H3 and H2 is not.