figure you already have something like this, but i thought i'd throw it out
here, anyway.

it creates the code to recreate the ranges in the immediate window. then they
can be copied and pasted into a module to recreate the ranges.

like i said, not that you don't already have something, but maybe someone else
doesn't.

Sub create_ranges2() '
Dim nm As Name
sName = ActiveSheet.Name
For Each nm In ThisWorkbook.Names
Debug.Print "ActiveWorkbook.Names.Add Name:=" & """" & nm.Name & """" & _
", Refersto:=""" & "=" & sName & "!" & Range(nm).Address & """"

Next nm
End Sub


--


Gary


"Jim Thomlinson" wrote in message
...
Nope... The issue actually comes up if I do something as simple as insert a
page break or a print preview... It seems like anything to do with printing
causes the problem. I have also tried using Code Cleaner and opening it on a
different machine. I am guessing corruption.
--
HTH...

Jim Thomlinson


"Dave Peterson" wrote:

A complete guess...

If you change to a different printer does the problem go away?

Jim Thomlinson wrote:

I am working on a spreadsheet that I inherited and I am having a problem.
One
of the sheets performs fine until I do anything to print the sheet or to
modify any of the print settings. After that the sheet performance drops
off
and any actions slow down to a crawl (even just scrolling up an down is
painfully slow). It only effects this one sheet and all other sheets
perform
fine. The only way to fix the sheet is to close the spreadsheet and then
reopen it. It will once again work fine until I do anything associated with
the print functionallity. Before I go ahead and delete and re-create the
sheet (a task I am not looking forward to as it is full of named ranges and
such) I was wondering if anyone else has seen and rectified this problem. I
suspect that somehow the sheet has become corrupted in some way but I was
hoping someone else might have some guidance here.

As an aside it intermitenetly had the bizzare side effect of spontaneously
turning on Chip Pearson's RowLiner Addin when the print functionallity was
accessed. I completely removed the addin from my system but I am still
having
the problem.
--
HTH...

Jim Thomlinson

--

Dave Peterson