| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
Threaded Mode
