View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ms_M_o_n_i_c_a Ms_M_o_n_i_c_a is offline
external usenet poster
 
Posts: 13
Default Absolute Formula Help

im trying to do the same thing and the indirect function is now working for me
--
I will Excel at Excel!


"pinmaster" wrote:


Try:

=INDIRECT("Sheet1!A1")

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498139