Home |
Search |
Today's Posts |
#1
|
|||
|
|||
naming formula
i was trying to name a fomula
<=vlookup($B6,table,3,false) now in the name the B6 is with respet to the sheet in which I originally named the formula. But I would like the name to take the B6 of the acitve sheet. I realise this can be done with a vba procedure. But is it possible to use worksheet function in this case. I hope I made mself clear. if the name is rv when I use this name in sheet1 it should refer to sheet1-B6. If i use that name in sheet2 it should refer to sheet2 B6. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |