I'm trying to loop through column of text for a word (SECTIONS) and
another (GROUPS). Where these are in the column varies although they
appear in that order. The two words frame a range that includes from 4
to 15 cells.


trycell = c.Value
If trycell = "SECTIONS" Then
c.Activate
rngStart = c.Offset(1, 0)


it's part of a for...next loop with a nested if. rngStart is dim'd as a
range,
but the c.Offset( 1,0) defaults to returning the value in the cell. I
need the range from that and the range from the second word to assign
it to a variable. I will be using the values from the selected range to
create an array. I haven't found anything in 'help' about returning a
cell address. Any ideas would be appreciated.

Andy