| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Using a named range in a header with VBA?
It doesn't look related to me. A long-shot, but check if you have any
missing references (ToolsReferences), uncheck them if so. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ups.com... It's not a word-wrap issue; I have it all on one line. As a test I closed Excel and re-started; I created the named range and started a new macro with only one line (the one you posted). That generated the same error when I ran it. I looked at the MS Knowledge Base and found an article http://support.microsoft.com/default...b;en-us;319832 that talks about unqualified references in VB (not VBA). Could this be a similar situation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named range with filter | Excel Worksheet Functions | |||
| Passing Excel NAMED Range to VBA | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
