hi
excel has lost it's used range reference. this happen now and then. to reset
your used range reference, see this site.
http://www.contextures.com/xlfaqApp.html#Unused
shows a way to manually reset or programicly reset.
regards
FSt1
"peterpeter" wrote:
I have a fairly large but simple [Excel 2003] spreadsheet with simple
formatting (number, text & date) with some comments inserted. No formulae are
in use.
I have recently 'shared' the workbook.
I want to hide some columns, however i get the error message "cant shift
objects off page".
This did not happen prior to sharing & even when i have 'unshared' it i
still get the message.
There are no objects that i can see.
Is there a way to check if and where an object may be or does anyone have
any ideas what could be causing my problem?