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
|