Hi,
Occasionally 'Named Ranges' misbehave and generate a Run Time Error 1004, probably due to my ignorance of the deep dark secrets of 'Named Ranges'. There are Global 'Named Ranges' associated withe the entire Workbook, and local 'Named Ranges' associated with just one Sheet. I probably defined the 'Named Ranges' that were defined with VBA as Global, when they should have been Local (one Sheet only).
To solve the problem, and alleviate my splitting 'Named Range' headache, I modified the code to not use 'Named Ranges' at all. The 'Named Ranges' you already have will do no harm.
To implement the changes in your file that already contains the code:
a. Make a backup copy of your file.
b. Open my file.
c. Presss ALT F11 to access VBA.
d. Press CTRL R to accces Project Explorer (if is not already visible).
e. Right Click the following modules and Export them (will not affect this file):
(1) ModPrettyPrint
(2) ModToolsAndUtilities
f. Close my file.
g. Open your file.
h. Press ALT F11 to access VBA.
i. Press CTRL R to accces Project Explorer (if is not already visible).
j. Right Click module 'ModPrettyPrint' and select 'Remove ..." to delete the Module.
k. Right Click module 'ModToolsAndUtilities' and select 'Remove ..." to delete the Module.
l. Right Click any module from your file in Project Explorer and import the following modules:
(1) ModPrettyPrint
(2) ModToolsAndUtilities
m. Software Installation completed. Save your file.
Small changes made in Module ModPrettyPrint Sub PaginateQuoteSheet() at approximately line 587:
Changes made in Module ModPrettyPrint (complete rewrite):
Changes made in Module ModToolsAndUtilities (complete rewrite):
I apologize for the inconvenience.
Lewis
Bookmarks