cell address

[lilachd]

Hi,

I know how to find a value in the worksheet and to find the cell address.

But how can I go to the next row or colum from the finding address

thanks lilach

 

[Tushar Mehta]

Assuming you are refering to Excel, add 1 to the row/column of the
address you have found.

Do keep in mind that in most cases one doesn't need to 'go' to a cell to
work with it. For some examples see
Beyond Excel's recorder
http://www.tushar-
mehta.com/excel/vba/beyond_the_macro_recorder/index.htm
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

 

[lilachd]

Hi,
thank's
but I did'nt find there hoe to add 1 to the row/column of the
address I have found.
can you be more specific?

Thanks

 

[James Wellington]

Use offset. Activecell.offset(0,1).value will return the value of the cell
1 column over.

 

[Jef Gorbach]

Hi,
thank's
but I did'nt find there hoe to add 1 to the row/column of the
address I have found.
can you be more specific?

Thanks

Post how you're finding the cell and I'm sure someone can provide
adjustment.

 

[lilachd]

Thank's
It was helpfull.

Use offset. Activecell.offset(0,1).value will return the value of the cell
1 column over.