Thread: offset row not column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default offset row not column

Since we don't know the column of the activecell, how about

cells(activecell.row,"ar")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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 (????

Reply With QuoteReply With Quote