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
|