Not sure what exactly you are trying to do, but you can do:

Dim r as long

r = 14\2
Cells(r, 3).Select


RBS


"rnrxtreme" wrote in message
...

Display where?

msgbox activesheet.cells(cint(14/2),13).value

--
Tim Williams
Palo Alto, CA


"rnrxtreme" wrote in message ...

=INDIRECT("M" & 14/2)

or for more flexibility:

=INDIRECT("M" & A1/A2)
where A1 contains 14 and A2 contains 2

or even:

=INDIRECT(A3 & A1/A2)
where A3 contains "M"

Regards

Trevor


"rnrxtreme" wrote in message
...

Thank you very much.

Does this not work when there's a text command in the equation

I'm inputting =INDIRECT("B" & ROUNDDOWN($AA$1/$A11^D$37,0))

(all listed cells exist)

and it shows an error...

You need to check what ROUNDDOWN($AA$1/$A11^D$37,0) evaluates to. It
needs to be a number between 1 and 65536. If it is likely not to be a
number you'll need to put some error checking in it and decide what you want
the value to be if there is an error.

Regards

Trevor


"rnrxtreme" wrote in message
...
Does this not work when there's a text command in the equation

I'm inputting =INDIRECT("B" & ROUNDDOWN($AA$1/$A11^D$37,0))

(all listed cells exist)

and it shows an error...