check blocks in loop

[sybmathics]

Hi,

In a spreadsheet i want to check different sections for the presence of
value.

These sections are declared as block1, block2 .... block9.

Now I want a routine that loops through all 9 secioins or blocks where 1 is
raised to 2, 2 is raised to 3 etc.8 is raised to 9.

I this possible?

--
||//////||
( o o )
( O )
-
( )
( )
(______O______)

 

[Bob Phillips]

Not really clear but maybe

For each cell in block1
'do something
Next cell

For each cell in block2
'do something
Next cell

'etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[sybmathics]

Not really clear but maybe

For each cell in block1
'do something
Next cell

For each cell in block2
'do something
Next cell

'etc.

Thanks Bob for your quick reply.

What I'm looking for is something like

for counter is 1 to 9
for each cell in block&counter
do something
next cell
next counter

But the concatenation does not work.
There doesn't appear to be 1 string created because vba adds a space.

Maybe a bit clearer?

Any help is greatly appreciated.

greets

Sybmathics

 

[Ardus Petus]

If your blocks are named ranges:

sub LoopBlocks
dim i as integer
dim rBlock as range

for i = 1 to 9
set rBlock = Range("block" & i)
<do something with rBlock>
next i

end sub

HTH

 

[sybmathics]

Yes,

I see what you mean.

This one will certainly take me further.

Thanks a lot .

Cheers everybody!!

Sybmathics