View Single Post
  #3   Report Post  
Don Guillett
 
Posts: n/a
Default 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