Excel Cell button to Clear set Ranges

Good Morning,

I'm trying to use cells in dynamic column H to change certain values in other columns for that corresponding row only.

I'm trying to use the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by mehmetcik

Please Login or Register  to view this content.

Thank you, would you mind explaining the steps in your code?

Getting "Endif without Block If" error.

It's simple to delete the line of (End If) to remove the error
It's working well after removing this line

Try this :

Please Login or Register  to view this content.

Thanks,

I'm not sure I understand the Range("A12,B2,C3") part.

Originally Posted by MarvinP

Does this kind of code help? It will only fire if you double click between H1 and the last row that has data in column H.

Please Login or Register  to view this content.

Thanks,

How would I modfy this for a dynamic named range in column H called "ClearList"?

May be like that :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by mehmetcik

Please Login or Register  to view this content.

Thank you!

Originally Posted by YasserKhalil

May be like that :

Please Login or Register  to view this content.

Using

Please Login or Register  to view this content.

Gives me error "Method Range of Object Worksheet failed "

Never mind I think it's fixed. Thanks for the help!

You should have a named range (ClearList)
Formulas Tab >> Name Manager >> Click New >> In the Name Field type ClearList >> In Refers To Field Type:

Please Login or Register  to view this content.

You can change the start point of the range

Yep for some reason I changed the names of the ranges and they didn't save so when I was referring to "ClearList" it was actually named as something else. Thanks!