Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Proper syntex to use | Excel Discussion (Misc queries) | |||
Can anyone tell me the proper code to copy a range... | Excel Programming | |||
Syntex Error ?? | Excel Discussion (Misc queries) | |||
Please help to correct syntex error | Excel Programming | |||
What syntex to find text | Excel Programming |