offset row not column
 

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

activecell.offfset (????

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

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

offset row not column
 

On Jul 18, 3:43*pm, Atishoo wrote:
I want to return a value contained in the column "ar" and in the same row as
the active cell

activecell.offfset (????

Range("AR" & ActiveCell.Row)?

offset row not column
 

great works no probs! am using it to control a web box so it returns the
patient whos range your looking ats database info as well its kick ass now
ta v much

"Don Guillett" wrote:


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

offset row not column
 

We are all glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Atishoo" wrote in message
...
great works no probs! am using it to control a web box so it returns the
patient whos range your looking ats database info as well its kick ass
now
ta v much

"Don Guillett" wrote:


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