View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sanduleac@googlemail.com is offline
external usenet poster
 
Posts: 2
Default 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