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