Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
line not accepted ?
how can i do this . I cannot use Union as the order in which the cells are
looked at changes. rngTarget = Range("B3:C11,E3:F11,H3:I11,K3:L11,N3:O11,Q3:R11,T 3:U11,B12:C20,E12:F20,H12:I20,K12:L20,N12:O20,Q12: R20,T12:U20,B21:C29,E21:F29,H21:I29,K21:L29,N21:O2 9,Q21:R29,T21:U29,B32:C40,E32:F40,H32:I40,K32:L40, N32:O40,Q32:R40,T32:U40,B41:C49,E41:F49,H41:I49,K4 1:L49,N41:O49,Q41:R49,T41:U49,B50:C58,E50:F58,H50: I58,K50:L58,N50:O58,Q50:R58,T50:U58") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
line not accepted ?
Why does that stop you using Union?
-- HTH Bob Phillips "Sunil Patel" wrote in message ... how can i do this . I cannot use Union as the order in which the cells are looked at changes. rngTarget = Range("B3:C11,E3:F11,H3:I11,K3:L11,N3:O11,Q3:R11,T 3:U11,B12:C20,E12:F20,H12: I20,K12:L20,N12:O20,Q12:R20,T12:U20,B21:C29,E21:F2 9,H21:I29,K21:L29,N21:O29, Q21:R29,T21:U29,B32:C40,E32:F40,H32:I40,K32:L40,N3 2:O40,Q32:R40,T32:U40,B41: C49,E41:F49,H41:I49,K41:L49,N41:O49,Q41:R49,T41:U4 9,B50:C58,E50:F58,H50:I58, K50:L58,N50:O58,Q50:R58,T50:U58") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
line not accepted ?
Since the range follows a regular pattern it doesn't seem necessary to
define the entire thing at once, particularly as you seem interested in processing the cells in a specific order. What are you using the range for ? set rngTarget=shtSomeSheet.range("B3:C11") for m=1 to 3 'or whatever.... for n=1 to 7 set rngTarget=shtSomeSheet.range("B3:C11").offset((m-1)*9, (n-1)*3) 'do something with the range next n next m Tim. -- Tim Williams Palo Alto, CA "Sunil Patel" wrote in message ... how can i do this . I cannot use Union as the order in which the cells are looked at changes. rngTarget = Range("B3:C11,E3:F11,H3:I11,K3:L11,N3:O11,Q3:R11,T 3:U11,B12:C20,E12:F20,H12: I20,K12:L20,N12:O20,Q12:R20,T12:U20,B21:C29,E21:F2 9,H21:I29,K21:L29,N21:O29, Q21:R29,T21:U29,B32:C40,E32:F40,H32:I40,K32:L40,N3 2:O40,Q32:R40,T32:U40,B41: C49,E41:F49,H41:I49,K41:L49,N41:O49,Q41:R49,T41:U4 9,B50:C58,E50:F58,H50:I58, K50:L58,N50:O58,Q50:R58,T50:U58") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From Accepted Bid to Purchase Order | Excel Discussion (Misc queries) | |||
How to define the accepted levels for monitoring the score? | Excel Discussion (Misc queries) | |||
No. of digits accepted in one cell | Excel Worksheet Functions | |||
? format column so no duplicate entries are accepted | Excel Worksheet Functions | |||
using a selection box and moving the accepted data | Excel Worksheet Functions |