Seek help to exceed limit excel 65536

[apple]

Hi All,

Can anyone let me know the method to bring my item number to next page if my item number exceed cell 65536? As we know Microsoft Excel 2003 only limited cell 65536. How can i bring the following item number to the next page when the item number reach cell 65536?
Hope to hear from you soon.

Thank you

Regards,
Apple

[Bob Phillips]

I think we need more details on what you are doing, what code you have, how you want ro do it, etc.

[ProteanBeing]

If the user is entering in the item number (or it's program generated) divide the number by 65536, truncate the number and that is the sheet number that you need (+1). For example if the item is 100000 then 100000/65536 = 1.5258. Remove the decimal and you are left with 1. Add one to the answer and you get 2. Your item is on worksheets(2).