Set range address as variable and then clear the cell via the variable

Is there a way to declare a cell's address as a variable and then clear the cell via the variable?
I thought of using:

Please Login or Register  to view this content.

...but to no avail
Looking for some guidance on this issue.
Thanks!

You can only set an object to object variable and a string is not, but range is. You can find the range address by using the find function and returns fixed address.

Please Login or Register  to view this content.

BSB

Originally Posted by AB33

You can only set an object to object variable and a string is not, but range is. You can find the range address by using the find function and returns fixed address.

I was trying everyway possible and i just posted one of the ways, sorry about that