View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default is it possible to refer to a cell using an expression?

Look at the indirect function - if you want examples google Excel indirect.
--
Wag more, bark less


"MatthewS" wrote:

I'm not sure if it matters, but mainly I am asking for Office 2007.

I'd like to know if it's possible to refer to a cell, in the following manner:

Assume I would like to refer to cell A8, so normally I would simply type:
=A8
.

However, would I be able to do the same thing doing anything along the lines
of:
=A(5+3)

or if cell B1 is equal to 8, could I write:
=A(=B1)

or anything else along this line of thinking...

... any assistance would be great. I very much appreciate your time, and
hope to hear from someone soon. Thanks!!