I have a sheet which has several columns locked and I want to assign values
from these cells to a variable. How can this be done from one of the cells
which is not protected?

Many Thanks

Hi Jimbob,

After searching this group for keywords "assign cell value to
variable" and "unprotect", I found these.

you could assign value to variable like:
myValue = Range("A2")

You may need to unprotect the sheet first:

Sheets("SheetName").Unprotect "PassWord"

And then protect the sheet:

Sheets("SheetName").Protect "PassWord"

A clearer description of your goals may generate a more complete
response.

HTH

Dan