Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax problem fassing named range into function
Hi,
I have a function that works when I pass in a string for a range name I need to extend it to use an array and then loop it. Can't figure it out. Any help appereciated Works If NameExists("exampleRangeName", Workbooks(ActiveWorkbook.Name)) Then Doesn't work MyRange(1,1)="exampleRangeName" If NameExists((myRange(1 1)), Workbooks(ActiveWorkbook.Name)) Then Function NameExists(WhatName As String, Optional WB As Workbook) As Boolean Dim N As Long On Error Resume Next 'Y = WB.Name N = Len(IIf(WB Is Nothing, ThisWorkbook, WB).Names(WhatName).Name) NameExists = (Err.Number = 0) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax for getting value of named workbook range | Excel Programming | |||
Named Range Problem | Excel Programming | |||
Syntax problem defining range for pivot table | Excel Programming | |||
named range problem | Excel Programming | |||
syntax to go to a named range | Excel Programming |