Hi
I would like to write a macro that will fill the next blank cell with data
Example attached
I want to enter the total in f5 into the next blank cell in g5 to r5 using a macro that will be activated by a button
Any help would be appreciated
Hi
I would like to write a macro that will fill the next blank cell with data
Example attached
I want to enter the total in f5 into the next blank cell in g5 to r5 using a macro that will be activated by a button
Any help would be appreciated
Last edited by Karen311261; 10-20-2010 at 04:00 PM.
Hello Karen311261,
The macro below will locate the first empty cell within the range of "G5:R5" and copy "F5" into it. If there are no empty cells then a message is displayed tell you this. The macro has been added to a button on Sheet1.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith
This works a treat. I have added it to my worksheet, but I would like to be able to carry out the smae function on several rows of data. the rows are 28.46.54.66 and 73.
Is there any easy way to adapt the code or could I create a new macro for each, but I would like to call them from the same button.
Thanks for your help
Kind Regards
Karen
Hello Karen,
here is the updated macro and workbook.
Please Login or Register to view this content.
Thank You very much for your help
Works well
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks