Thread: How do I reference the cell address next to Active cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default How do I reference the cell address next to Active cell
Hi
to reference the cell next to the active cell you may use
activecell.offset(0,1).value = your_lookup_value

--
Regards
Frank Kabel
Frankfurt, Germany

Nico Le Roux wrote:
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

Reply With QuoteReply With Quote