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

What is the proper syntex for .cells or .range ?
 

On 27 Maj, 04:11, cgnotrom wrote:
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

Hi Chris

Here's a way to do it:

Dim TargetRange As Range
Set TargetRange = Range("M1:O10")

For Each c In TargetRange
MsgBox c.Value
Next

Regards,
Per