Error 1004 Unable to set the Hidden Property of the Range Class

**nld** · 08-02-2007, 07:17 AM

Hi All
The following peice of code has been working perfectly but now for some reason is causing the above error.
Can anyone help?
Thanks
nld

Please Login or Register  to view this content.

**JR@SGC** · 08-02-2007, 07:26 AM

Hi,

The codes fine can you attach the workbook?

Please remember to delete any confidential data!

**nld** · 08-02-2007, 11:08 AM

For some reason, which I cannot put my finger on, it now works again.
I have re-started PC, re-opened workbook and numerous re-coding's and nothing. I opened a backup copy and pasted some data from one sheet that was missing from a worksheet and it started working again.
I'm not saying any of these solved it but solved it is.
Thank you for looking and thanks for reply.
nld