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

"Mindie" wrote in message
...
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?


It just struck me that you should be able to use the OFFSET function
http://www.techonthenet.com/excel/formulas/offset.htm

You could do something like this in Sheet3

=OFFSET(Sheet1!$B$3, A1,0,1,1)

The idea is that when new rows are inserted, you enter the number of rows
inserted as the offset in cell A1 in Sheet3. You could also add some code to
tour macro that would insert this number in A1

/Fredrik