error unhiding a row

[wotadude]

I get an error (Method 'Range of object _Global' failed) when attempting to unhide a row in a worksheet.
I require this line of code to display a certain row if the range named R_AAAH exists.
This specific named range does not exist.
But when using On error ..... why should i still get this errror ?
And how can i solve it.
I was hoping to avoid testing if the range exists first.

Please Login or Register  to view this content.

[Leith Ross]

Hello wotadude,

The code syntax is correct and works on my machine correctly. Have you retyped the code? I have found on occasion this works for problems that shouldn't be problems. If you still have trouble, post your workbook for review.