moving thru a noncontiguous range
Hello
on sheet1 i have 24 columns 12 of which represent the months of the
year with the adjacent column containg containing either a letter D or
N, denoting wether a day or night shift is worked on particular date.
how can i best represent this in VBA so that i can 'loop' thru each day
of each month and look across to the adjacent column to see what shift
is worked.
regards
San
|