unable to ClearContents on a Merged Cell using VBA

I have the following VBA Code to clear contents on 3 Cells 2 of which a merged cells:

Please Login or Register  to view this content.

I don't have any issues with the 1st of the 3, that one just time stamps a cell and clears it because that one doesn't involve a merged cell.
The bottom 2 are my issues. I need it so that I enter a name into B7 that then date stamps B8 and adds a naming convention for users to save the file with under cell J8
Cell B8 is merged as following: B8:H8
Cell J8 is merged as following: J8:Z8

I am very new to VBA and only understand very little of its jargon. I have basically pieced this together from other threads I have seen and altered it for my own use.
Appreciate any help I can get.
Cheers

Thanks Izandol, but that hasn't seemed to fix the issue, it is still not clearing the merged cells.

Originally Posted by Izandol

You may use:

Please Login or Register  to view this content.

One thing that I just noticed in my spreadsheet is, that when I manually clear contents in cell B7 it isn't clearing the contents on my other 2 cells, HOWEVER, if I then double click to enter into cell B7 and then exit out of the blank cell, it does clear the contents of the 2 merged cells.
So is there something wrong with part of my code?

test.xlsm

Thanks jaslake
but that also didn't work.

I have attached a secondary workbook that has the same properties as the original one that I need this to work for. Unfortunately I cannot provide you with the original, not to mention that it has data in it making the file size upwards of 20mb.
Hope this helps.
Cheers

Hi Leggs11,
maybe so
in B8

Formula:

Please Login or Register  to view this content.

in J8

Formula:

Please Login or Register  to view this content.

Thanks nilem,
Formula's I have no trouble with, I can easily have the formula's in there, however I need the users to be able to double click in the cell and copy and paste from there, copying and pasting from outside the cell doesn't work for what we need, and if I have a formula then when double clicked it just enters into the formula code, unless I have the cell as 'hidden' and then when double clicking it deletes the text in the cell.

Thanks nilem,
Formula's I have no trouble with, I can easily have the formula's in there, however I need the users to be able to double click in the cell and copy and paste from there, copying and pasting from outside the cell doesn't work for what we need, and if I have a formula then when double clicked it just enters into the formula code, unless I have the cell as 'hidden' and then when double clicking it deletes the text in the cell.

I have discovered that my issue is now only with the Cell "B7", I have adjusted the code and it can now clear the contents of merged cells B8:H8 and J8:Z8 if cell B7 is NOT merged. But it will not clear the contents of the 2 cells while it is merged as B7:H7.

the code is currently:

Please Login or Register  to view this content.

YES!! thank you so much Izandol!!, that has fixed it perfectly.
and I can now publish my spreadsheet for use

Thanks for everyones help on my issue.
Cheers.