Refrence next blank cell to repeat VBA Code

Hi All,
First go here so i hope someone can help me out. I have recorded a macro that copies the date and other selected data on the attached spread sheet to create a history of my Count and Purchase Colums, but what i need the macro to do now is have it repeat for every time i do a new count, so it selects the next blank cell in Row 10 and pastes the new count and purchase that i do there thus creating a history.
Hoping some one can help me out


Cheers,
Austin

Welcome to the forum SirAustin1.

Please take a moment to read the Forum rules and add CODE tags to your code example.

It may help others to help you if you post a sample workbook with some typical data rather than post the code out of context.

Regards

Thanks for updating the post.

You're probably better using row 11 as the merged cells in row 10 won't give you what you want/expect.

Please Login or Register  to view this content.

The first example gives you the next free column in row 11 and the second gives you the next available cell address on row 10.

In the VB Code, you would use something like:

Please Login or Register  to view this content.

Hope this helps.

Regards

Thanks for the advise so far, I have added in the codes to refrence the next available cell, unmerged cells where it was said it may be a problem but still the macro runs over the same spot and im trying to get it to repeat itself. Since it is my birthday today and i have blown out my candles, i would like to wish for someone to help me figure this one out. I have reattached the spread sheet.