Object defined error?

[cheoksoon]

Hi everyone,

Can someone help me debug this code?

Dim ws1 As worksheet
Set ws1 = Sheets("assets")

Dim add As string

add = Selection.Address

ws1.Range(add).Unmerge

 

[DanteAmor]

Works for me?
In which line do you have the error?
Do you have the protected sheet?

 

[Joe4]

What cells are merged?
What cell is your cursor on when you run the code?

 

[cheoksoon]

Works for me?
In which line do you have the error?
Do you have the protected sheet?

Sorry everybody, false alarm.

My sheet was protected. Ooops... Problem solved when I unprotect the sheet.

Consider the matter resolved.

Thanks!

 

[DanteAmor]

Sorry everybody, false alarm.

My sheet was protected. Ooops... Problem solved when I unprotect the sheet.

Consider the matter resolved.

Thanks!

I'm glad to help you. Thanks for the feedback.