ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
I have some text in cell A3 which is merged with cell A4
In a line of code i use i have the following.
I see the error message "Cant change part of a merged cell"
I click ok etc but the value in the cell A3 is cleared no problem.
How can i clear the contents without the error message.
Please advise thanks.
In a line of code i use i have the following.
Rich (BB code):
Range("A3").ClearContents
I see the error message "Cant change part of a merged cell"
I click ok etc but the value in the cell A3 is cleared no problem.
How can i clear the contents without the error message.
Please advise thanks.