Hi,

I am pretty new to arrays in VBA, as in I'm having a little trouble understanding how they work. I have been trying to find other forum threads which might have a similar issue/solution to my problem, but only managed to piece together only some of the parts.

The following is the code I am trying to work on:

Please Login or Register  to view this content.
The following is a description to better understand the coding:
(1) B1 to B8 are all worksheets.
(2) B1 worksheet should always be print previewed.
(3) B2 to B8 should only be print previewed based on the conditions found in sheet AT - Range O38 till O44 (a total of 7 cells)
(4) If, within ranges explained in note (3), the values include "Not Applicable" then such worksheet should not be included in the array to be print previewed.

If anyone has any ideas, help is always appreciated.

Many Thanks!!!