Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a function for getting the content of a cell?
I have 2 variables which determine the row and the column of a cell. I need to find out the number in that cell. For example, if I have i=4 and j=2 then I need the number in B4. But I can't write "=B4" because i and j are variables therefore I need something like this "=cell_content(4;2)". -- tzvarza` ------------------------------------------------------------------------ tzvarza`'s Profile: http://www.excelforum.com/member.php...o&userid=28765 View this thread: http://www.excelforum.com/showthread...hreadid=484522 |
#2
|
|||
|
|||
is there a function for getting the content of a cell?
On Sat, 12 Nov 2005 07:28:16 -0600, tzvarza`
wrote: I have 2 variables which determine the row and the column of a cell. I need to find out the number in that cell. For example, if I have i=4 and j=2 then I need the number in B4. But I can't write "=B4" because i and j are variables therefore I need something like this "=cell_content(4;2)". =INDIRECT(ADDRESS(row_num,col_num)) --ron |
#3
|
|||
|
|||
is there a function for getting the content of a cell?
in a macro
i=4 j=2 cells(i,j) -- Don Guillett SalesAid Software "tzvarza`" wrote in message ... I have 2 variables which determine the row and the column of a cell. I need to find out the number in that cell. For example, if I have i=4 and j=2 then I need the number in B4. But I can't write "=B4" because i and j are variables therefore I need something like this "=cell_content(4;2)". -- tzvarza` ------------------------------------------------------------------------ tzvarza`'s Profile: http://www.excelforum.com/member.php...o&userid=28765 View this thread: http://www.excelforum.com/showthread...hreadid=484522 |
#4
|
|||
|
|||
is there a function for getting the content of a cell?
Will this work for you?: =OFFSET($A$1,I1-1,J1-1) Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=484522 |
#5
|
|||
|
|||
is there a function for getting the content of a cell?
The function ADDRESS is what I tried to use, but didn't manage to get the actual number. Now I tested INDIRECT(ADDRESS(row_num,col_num)) and it works just fine :D 10x for your help -- tzvarza` ------------------------------------------------------------------------ tzvarza`'s Profile: http://www.excelforum.com/member.php...o&userid=28765 View this thread: http://www.excelforum.com/showthread...hreadid=484522 |
#6
|
|||
|
|||
is there a function for getting the content of a cell?
On Sat, 12 Nov 2005 07:55:25 -0600, tzvarza`
wrote: The function ADDRESS is what I tried to use, but didn't manage to get the actual number. Now I tested INDIRECT(ADDRESS(row_num,col_num)) and it works just fine :D 10x for your help You're welcome. Thanks for the feedback. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
Use Cell Content to Build Link | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) |