G
Geoff
Hi
I have a wsheet with data from A1 to AJ1394 or so it seems. Yet if i do
Ctrl + End the sheet scrolls to AJ31954.
There is no apparent data on row 31954 and running the little utility
recently posted to show the last real row and column produces the last cell
address as AJ1394. This seems to make sense as that is the end of the
observable data.
However if I do n Autofilter to show blank cells, the range produced shows
all the way to row 31954. Curious.
Assuming the sheet had not been saved after doing whatever work, I saved the
wbook expecting to see the slider bars much enlarged reflecting the real
data. But that was not the case.
This is an important issue because one of the operations I need to do is
delete entire rows if there are blank cells in Column 'foundfax' using:
On Error Resume Next
.Columns(foundFax).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
I am not sure whether this stops at the last row of UsedRange or goes all
the way to 65536. But whatever, I have all sorts of operations which examine
the data and there is no point in doing an unnecessary extra 30,000 rows.
Can anyone throw some light on this please.
T.I.A.
Geoff
I have a wsheet with data from A1 to AJ1394 or so it seems. Yet if i do
Ctrl + End the sheet scrolls to AJ31954.
There is no apparent data on row 31954 and running the little utility
recently posted to show the last real row and column produces the last cell
address as AJ1394. This seems to make sense as that is the end of the
observable data.
However if I do n Autofilter to show blank cells, the range produced shows
all the way to row 31954. Curious.
Assuming the sheet had not been saved after doing whatever work, I saved the
wbook expecting to see the slider bars much enlarged reflecting the real
data. But that was not the case.
This is an important issue because one of the operations I need to do is
delete entire rows if there are blank cells in Column 'foundfax' using:
On Error Resume Next
.Columns(foundFax).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
I am not sure whether this stops at the last row of UsedRange or goes all
the way to 65536. But whatever, I have all sorts of operations which examine
the data and there is no point in doing an unnecessary extra 30,000 rows.
Can anyone throw some light on this please.
T.I.A.
Geoff