Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate a Name in Non-active WB
Anyone know the syntax to evaluate a Name in a Workbook that's not the
activeworkbook. For example, in the following how to return v = 123 if ThisWorkbook is NOT the active workbook (without using cells). Sub EvalNameTest() Dim v With ThisWorkbook.Names .Add "abc", "=123" v = [abc] .Item("abc").Delete End With If IsError(v) Then v = CStr(v) End If MsgBox v, , ActiveWorkbook.Name End Sub TIA, Peter T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
run macro although blinking cursor is active in an active cell | Excel Programming | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
How to write vba to evaluate the text font and size on an active cell range? | Excel Programming | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) |