View Single Post
  #5   Report Post  
 
Posts: n/a
Default Using a named range in a header with VBA?

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?