Hi
I need to clear all data that may be on a sheet except for the firs
two rows. I have tried to use:
EXCEL::_WORKSHEETPTR OBJSHEET;
....
EXCEL::RANGEPTR RANGE = NULL;
RANGE = OBJSHEET-GETUSEDRANGE();
LONG LROW = (RANGE-GETEND(XLDOWN))-GETROW();
LONG LCOL = (RANGE-GETEND(XLTORIGHT))-GETCOLUMN()
to get the extents of the used range but in some instances GetRow(
returns 65536 which causes my code to puke.
Anyone have a better way of doing this? Is there any useful (thi
automatically excludes MSDN) information out there on this sort o
thing?
Thank
--
5lmustan
-----------------------------------------------------------------------
5lmustang's Profile:
http://www.excelforum.com/member.php...fo&userid=1548
View this thread:
http://www.excelforum.com/showthread.php?threadid=27068