is there a function for getting the content of a cell?

[tzvarza`]

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)".

[Don Guillett]

in a macro

i=4
j=2
cells(i,j)

--
Don Guillett
SalesAid Software
[email protected]
"tzvarza`" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ron Rosenfeld]

On Sat, 12 Nov 2005 07:28:16 -0600, tzvarza`
<[email protected]> 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

[Ron Coderre]

Will this work for you?:
=OFFSET($A$1,I1-1,J1-1)

Regards,
Ron

[tzvarza`]

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

[Ron Rosenfeld]

On Sat, 12 Nov 2005 07:55:25 -0600, tzvarza`
<[email protected]> 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