View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cgnotrom cgnotrom is offline
external usenet poster
 
Posts: 14
Default What is the proper syntex for .cells or .range ?

Hi All
I am trying to read the array (m1:O1) in a Range command

using a for next loop where 'gm' is the incrementor
For gm =1 to 10

need to convert .Range("M1:O1") to increment .Range(gm,13:gm,15)
or .Cells(gm,13:gm,15)
neither seems to get past the debugger.
Thanks for any guidance !
Chris