Hey!
What I’m trying to do is simply clear the contents of 2 different merged cells named “FirstName” and “LastName” on the click of a cmd button, which I have already created and is already carrying out some functions. But this is proving much more difficult than clearing a non-merged cell. When I try: [VBA]range(“firstname”).clearcontents[/VBA]
This return an error saying you cannot edit a merged cell.
So I did a bit of internet research and it threw up this: http://antonio.beyah.net/blog/2008/04/08/vba-merged-cell-information/
This person appears to have worked it out, but me being very new to this I couldn’t make sense of it.
If anyone can make sense of it… and give me some help with it that would be great.
Cheers,
Joe