Macro to select sheet thatīs Hidden

[Portuga]

Hi,

Thanks for the reply DCSwearingen:

I am now trying to print this hidden sheet (1 page of data) so I changed the thread name.

Please Login or Register  to view this content.

The code above gives me an error.

Any way of printing the data from this hidden sheet?Thanks

[DCSwearingen]

Your macro probably tries to select or activate the hidden worksheet.

Are you searching a range of cells?

All you need to do is reference the sheet without selecting.

I set up a two sheet workbook with a list of values in Sheet2.

I then used Sheet1 cell B2 to use as the value to find.

Put this code into the Sheet1 private module.

Please Login or Register  to view this content.

Changing the value in Sheet1 Cell B2, will place the address matching the value of B2 into C2. If no match is found it will clear C2.

Good Luck!!

[DCSwearingen]

See the code I have hi-lighted in your code. Hidden sheets cannot be selected.

Hi,

Thanks for the reply DCSwearingen:

I am now trying to print this hidden sheet (1 page of data) so I changed the thread name.

Please Login or Register  to view this content.

The code above gives me an error.

Any way of printing the data from this hidden sheet?Thanks

I have not tried this code and I am on my laptop away from a printer, but I think it will work. Any time you record and find a combination of ".select" in one line followed by "Selected" or "Selection", try deleting text between the "dot" before "select" and the "dot" following "Selected" or "Selection" similar to what I show in the folloing line.

Please Login or Register  to view this content.

[Portuga]

Hi Denis,

No joy on your suggestion, I think its because, (and following your logic on the "select" command), the "activeworkbook" comand wouldnt work either... because the workbook is not active...
(Circular reference?)

So Iīm basically left with the line:

Please Login or Register  to view this content.

Which works by the way... but not when the sheet is hidden!

So I decided to do a small test with another simple piece of code (with the sheet Hidden):

Please Login or Register  to view this content.

Puzzelled and defeated.
Thanks anyway

[DCSwearingen]

Please Login or Register  to view this content.

works when the sheet is visible, even if not selected in the sample workbook I attached earlier... It does not work if the sheet is hidden.

This may take some thought or one of the experts...