Setting height from another worksheet

[sparx]

Hi all, Im having difficulty trying to resolve my code that randomly generates an error message.

The aim of the code is to set the row height from a stored number from another worksheet called prefs.
When the worksheet prefs is password unprotected and cells visible, the code works.
As soon as I hide the cells and lock the page, the runtime error 91 message appears.
The line which is flagged up is the line below the on error resume next line.

Please Login or Register  to view this content.

Any help is much appreciated.

[nankw83]

Hi sparx,

Edit: After re-reading your question I noticed that you have your error message before my below assumption. It looks that the error you're getting is due to hidden cells where the Range.Find will not work unless you either unhide the cells, perform your code then re-hide or change your LookIn argument to xlFormula if your data is not formulas in the range

I have revised your code a little bit. I think the issue could be due to not assigning the Rows("4:33") as highlighted in red below to any sheet takes the active sheet. Try the below code & if you hit the same error message, try to assign the rows to a sheet

Please Login or Register  to view this content.

[sparx]

Hi nankw83, thank you for your help, I tried your code and assigned the rows as per your instruction.
The code didn't work but will try again in a bit.

The strangest thing is, if I keep the cells visible on the prefs sheet even if the worksheet is protected,
the original error does not show.

I normally hide cells I dont want people to see but unhid them, put text as size 1, white text so appears invisible,
and the orogonal code worked.
I like your way of code, its cleaner and easier to understand so will try to use it.

Ill let you know the outcome.

[nankw83]

I have made an edit in my first post, just see if it works with xlFormulas