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
Bookmarks