Cell range

[Al]

Hi All
In a macro I have found the address of a cell
and want to define a range starting with that cell.
Is there a way to do that?
Many thanks.
Al

 

[Peter Atherton]

-----Original Message-----
Hi All
In a macro I have found the address of a cell
and want to define a range starting with that cell.
Is there a way to do that?
Many thanks.

Al

something like

RAnge("A2".select
for each c in activecell.currentregion

or

Range("A2").select
r= currentregion.rows.count
col = currentregion.columns.count

for i = 2 to r
cells(i,whatever).value =cells(i,whatever)*2
next i

Regards
Peter

 

[Gord Dibben]

Al

Set myrng = Activecell.Resize(10, 10)

Gord Dibben Excel MVP