Yes, the pages are loaded from the top. From there on you lost me. I am not
much of a VBA programmer, I am more 400/mainframe. Any ideas?

"Fredrik Wahlgren" wrote:


"Mindie" wrote in message
...
I did not develop this program, I am just adding another page to it. Yes,
I
have tried using Sheet1!$B$3 and the rows still shift on me. Sheet 1 is
being
loaded by external data. Here is the code that they are using

' clear all the sheets
Call ClearAllCartoons
Call ClearAllDataSheets
' place the data on the sheet
Call InsertScheduleData(sText)
' sort
Call SortWorkBook
' set the print areas, this is done since the
deleteing
and adding of rows moves the current print row
' that problem may be resolved with absolute addresses
but this is easier.
Call SetPrintAreas
'ThisWorkbook

Are the rows inserted from the top? That makes things more complicated. If
you need to keep this logic, you would need a user defined function that
would have to depend on a global variable, an integer set to the number of
rows inserted. You would probably need to save the absolute offset
somewhere. This solution is pretty complex.

/Fredrik