Search:

Thanks A lot Eri and Dglienna.

I'm note sure what you're telling me to do. Bare with me since I'm not a vba user. This is my first attempt to write a macro. Basically, I need to specify in the code to exclude a sheet from being...

sorry this is what the code looks like now and Im getting a run-time error 1004: Method 'Select' of Object 'sheets' failed.

Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long
Sub...

I am now getting a compile error Next without For. Here is what my code looks like now, can you point the error?

Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long
Sub...

ok i will try now and let you know. thanks

Thank you.

I have tried y = 2 and it does not make a difference. I need like a select case code to exlcude sheet 1 from being retrieved.

thanks

Hello,

I am trying to create a macro in order to be able to retrieve all sheets in a workbook. Here is a "loop through all" code I used. The problem is that I want to exclude 1 of the sheets from...