Hi,
I had hoped to attach the small troublesome excel file (size: A1:F374) but just discovered I do not have permission. Not sure how to demo what the problem is without attaching the file - can I be given permission please?
The file has numerous zeros (0). I want to use Replace to replace all zeros with a one (1). However I get the message that this is a protected sheet and I should unprotect it. I don’t believe that is correct – I cannot seem to find that it is in fact protected. So, the net result is that I cannot do the replacing of zeros with ones. I would much appreciate your help please.
Thank you,
Alfie101.
I had hoped to attach the small troublesome excel file (size: A1:F374) but just discovered I do not have permission. Not sure how to demo what the problem is without attaching the file - can I be given permission please?
The file has numerous zeros (0). I want to use Replace to replace all zeros with a one (1). However I get the message that this is a protected sheet and I should unprotect it. I don’t believe that is correct – I cannot seem to find that it is in fact protected. So, the net result is that I cannot do the replacing of zeros with ones. I would much appreciate your help please.
Thank you,
Alfie101.