Cell range

  • Thread starter Thread starter Al
  • Start date Start date
A

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
 
-----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.
Click to expand...

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
 
Back
Top