View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default offset row not column

try range("ar" & activecell.row)

--


Gary


"Atishoo" wrote in message
...
I want to return a value contained in the column "ar" and in the same row as
the active cell

activecell.offfset (????