View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Cooper Rich Cooper is offline
external usenet poster
 
Posts: 35
Default creating a range by searching another worksheet

I am trying to build a range by having a procedure go through a range. I
have a range of markets. The range is column A. In column A at the very
top you have some summary information then you have M1P1,
M1p2...M2p2...M3p5... I am trying to create an array that will be ("m1",
"m2", "m3"...) but i am having trouble doing this. I can't get the
procedure to go throught the range. Any help on how to do this is greatly
appreciated.