I appreciate the advise from an expert. With what I was trying to accomplish
my code had to be written the way it was. I have fiexed the code so it works
with a hidden sheet. Thanks again for your opinions.

"Don Guillett" wrote:

You probably could have and SHOULD have used code that did not require
SELECTING. You should try to learn how to do it properly.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
This is what I was needing. Thank you for your help.

"Luke M" wrote:

How exactly are you referring to the cell in the macro? (code please!)

Could always try something like:

Application.ScreenUpdating = False
Sheets("YourSheet").Visible = xlVisible

'rest of code goes here

Sheets("YourSheet").Visible = xlVeryHidden
Application.ScreenUpdating = True
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

How do you run a macro when a reference is on a supper hidden sheet. I
am
getting an error if it is hidden. If not it works.

Thanks