View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_4_] Alan Beban[_4_] is offline
external usenet poster
 
Posts: 171
Default How do I reference the cell address next to Active cell

An alternative, probably faster, to ActiveCell.Offset(0,1) is
ActiveCell(1,2)

Alan Beban

Nico Le Roux wrote:
Thks Frank and Tom.

"Nico Le Roux" wrote in message
...

My user choose something from the my combo box and the VBA code add the
value to the active cell.

I would like to lookup this value in another range and add the result of


the

lookup to the right of the active cell.

Your help would be appreciated.

Regards
Nico