offset row not column

  • Thread starter Thread starter Atishoo
  • Start date Start date
A

Atishoo

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

activecell.offfset (????
 
Since we don't know the column of the activecell, how about

cells(activecell.row,"ar")
 
I want to return a value contained in the column "ar" and in the same rowas
the active cell

activecell.offfset (????
Click to expand...

Range("AR" & ActiveCell.Row)?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer array element offset value to a matched value 3
OFFSET LOOKUP function in VBA? 9
Import multiple workbooks to current workbook in specified row number 0
Dynamic Offset from an Application.Goto cell = Date or Time 10
lastrow function help 6
Return cursor to proper place 4
Column number of last column that returns value ignore formulas 8
VBA CreateNames (ignores last 5 rows?) 6

Back
Top