Named Ranges - Longer than 255 characters

[Anton Jansen]

I have 20 worksheets, named page 1 to 20,with data. To enable me to export a selected number of pages to a .pdf file, I have given a certain range a name. Example, page1 cells A1:G10 and cells A100:G110 the name is Page1 but ( Page1_A1:G10,A100:G110 when viewed in the name manager) I then hi-light page 2 (together with page 1) and give that a name. This name now Page 2 becomes longer when viewded in the name manager. e.g. Page1_2= Page1_A1:G10,A100:G110;Page_2,A1:G10,A100:G110 I don't know if this is clear but basically I want to export page 1 only by selecting it in the name box, then export maybe page 1 and page2 together by selecting this from the name box and so on. As the number of pages to be selected increase so does the range name in characters. When I got to page 16 this name length was 255 characters and I am stuck with not being able to select pages 1-17 or 1-18 etc. Can this names not be added?

 

[JLGWhiz]

You need to consider using a diffenent method of naming the ranges that will yield a shorter number of characters.

 

[Yongle]

I don't know if this is clear

- It isn't, but I think I understand your problem
- Page1_A1:G10,A100:G110 is invalid as both a range name and as a RefersTo value

Q1 Are you referring to the Named Range's RefersTo value?

Q2 Is this the correct RefersTo value?
=Page1!$A$1:$G$10,Page1!$A$100:$G$110

Q3 Are using VBA to do the exporting?
- please click on # icon above post window and paste the code between the tags
[ CODE ] paste your code here [ /CODE ]

thanks