Copy formula from above cell in protected worksheet

N

Nav

Hello

On a certain worksheet, the "lock" option from the cell protection (format
cells) has not been selected, but the "hidden" is selected and the sheet has
then been protected.

I am trying to copy the formula from the above cell (from the hidden cell)
to the cell below, but it just copies the text (values) from the above cell
not the formula. Is there a way to get around this or does the "hidden" also
have to be removed?

Any ideas/suggestions are appreciated.

Thank you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top