Print preview multiple sheets macro, based on cell value

[umberto79]

Hello dear Users,

Would anybody help me on the following issue;

I want a macro that based on the values in the cells , will print preview the particular sheets.
For example.
I have a GENERAL sheet and in row no.1 are written the names of the sheets:
C1 name is sheet1
D1 is ....empty....
E1 name is sheet3
etc....

I'm using a simple formula:
ThisWorkbook.Sheets(Array(range("C1").Value, range("D1").Value, range("E1").Value)).PrintPreview

Everything works fine..but the problem starts when the cell is empty "D1" in that case.

Is there any way that above formula will ignore the "blanks" and move to the next one (so it will go from C1 to E1 , when D1 is empty).

Many thanks for help

[maniacb]

You can place the following line before your code:

Please Login or Register  to view this content.

and before the end :

Please Login or Register  to view this content.