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