Thread: Simple way to get cell location as text "A2"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cKBoy
 
Posts: n/a
Default Simple way to get cell location as text "A2"

Is there a simple way that I can get a cell's current location as text
so I can use it on a formula?


For example I have 5 sheets and I want to get all the sum of the CELL
B2 on all the sheets. I would have a formula like
=Sheet2.B2+Sheet3.B2+Sheet4.B2+Sheet5.B2 <-- this formula would be on
Sheet1 B2. I need to get the "B2" from a formula ie.
Sheet2.(row(),column())? or something to this effect. And is there an
easier way to do this just by copying and pasting? or maybe a script?


--
cKBoy
------------------------------------------------------------------------
cKBoy's Profile: http://www.excelforum.com/member.php...o&userid=31522
View this thread: http://www.excelforum.com/showthread...hreadid=512106

Reply With QuoteReply With Quote