| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 (???? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 (???? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 (???? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 (???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET COLUMN() ROW() - what does this mean? | Excel Worksheet Functions | |||
| Offset from a variable column to a fixed column | Excel Programming | |||
| offset 1 row and return to first column | Excel Discussion (Misc queries) | |||
| ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1) | Excel Worksheet Functions | |||
| offset every nth column | Excel Worksheet Functions | |||
Linear Mode
