VB:ClearContents Error on Merged Cell - But I dont have Any Merged Cell

You do not have a code on the attached and not sure what are trying to do, but if you wish to remove merged cells, run this code.

Please Login or Register  to view this content.

Please do not reply with quote. It has not purpose, but clutters the space.
You have few codes on the attached. I suspect this code "Sub NextScreening()" you are looking at. Right! I will have a look and get back to ASAP

I am a noob for Excel. My current workbook is contributed from Excelforum the most and 30%-40% is from google.

I create a command button with Module1's macro on sheet1. And i wish to have the same command button on sheet2 with same function.
So i copy the button from sheet1, it works only if i click it from sheet1, but not sheet2. Whenever, i click it, it will show merged cell error or something.

Excel pointed this sheet1's cell (in red fonts) error.

Please Login or Register  to view this content.

Even i delete it, it will show error again on the following contents clearing.

I run your code and could not find any error. The code works as it intends, but you could add this line to prevent from error occuring.
Sub NextScreening()
On Error Resume Next

Ya, command button on sheet1, is working fine. But command button on Sheet2 error with merged cell. I tried on the line you mentioned above. When i click on the command button on sheet2, it dont clear of the error cells.

hi cychua, if we talk of sheet "Agent-Air", cells d20:d24 are merged. To avoid that error you can change this line:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I do not know which button on sheet1 you are reffering, but I run your code line by line and do not get an error.
You could try it yourself. Alt+F8 will take to module section, you then take your curson to the code you are trying to test it, While the cursor is inside the code, your press F8. It will go down line by line up the end. If there is an error on the code, it will stop it.
You could also unmerge the culprit range only
For e.g

Please Login or Register  to view this content.

Hi Watersev
I got no issue on "Agent-Sea"/Sheet1" 's command button.
When i click on the command button on "Agent-Air/Sheet2" 's command button, it showed error on cell merging.

Just curious to ask, i have coded it as below,

Please Login or Register  to view this content.

Isnt VB only refer to "Agent-Sea/Sheet1"? Instead of determine from "Agent-Air/Sheet2"

Just hope to learn more on this. To avoid future error like this again.

Sorry to get you confunse AB33.

Sheet1, i meant is "Agent-Sea"
Sheet2, is "Agent-Air".

@cychua,

if you explicitly specify sheet then it takes range from there, otherwise without specifying sheet VB understands it as the range reference on the sheet currently being active

No, there is nothing wrong with this line

Please Login or Register  to view this content.

You could also write this section like below as you did with the rest of your code.
I can see you have a button on sheet 2 callled "Save and Clear". is this button liked to other codes in your module?

Please Login or Register  to view this content.