In my worksheet I have a button which generates a new invoice number and clears the contents of certain fields. This is the code:
The problem I have is that some of the cells are merged cells and it won't let me do this. I thought I might be able to get around it by using a named range but that doesn't work either.
Please Login or Register to view this content.
Is there a way of clearing the contents of merged cells as well? The cells in question are D10, I6, C32, C33
Hi,
You should be able to use this with merged cells
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
IdeallyPlease Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks