Unable to get last filled cell address from Range.End(xlDown) method
 

The scenario is like this. I have one .Xla file which has a functio
called generateReport(). This function will retrieve the data fro
Database and display in excel sheet.

Multiple Queried will be executed by generateReport(). I need to kno
the last filled Row cell so that I can start next value form the nex
row. For this purpose I have used Range.End(xlDown) method to know th
last filled cell. But while debugging I found that xldown value i
-4121 and this method will return last row cell address. i.e. $A$65536
so if I tried to move to next row (Set Range.Offset(2, 0)) then runtim
error will be displayed. Who to resolve this problem? Is there is an
other method to get last filled cell address?

This .Xla file function will be called from VB application.

Thanks
Ve

--
vedpate
-----------------------------------------------------------------------
vedpatel's Profile: http://www.excelforum.com/member.php...fo&userid=3198
View this thread: http://www.excelforum.com/showthread.php?threadid=51720

Unable to get last filled cell address from Range.End(xlDown) method
 

See other post.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"vedpatel" wrote in
message ...

The scenario is like this. I have one .Xla file which has a function
called generateReport(). This function will retrieve the data from
Database and display in excel sheet.

Multiple Queried will be executed by generateReport(). I need to know
the last filled Row cell so that I can start next value form the next
row. For this purpose I have used Range.End(xlDown) method to know the
last filled cell. But while debugging I found that xldown value is
-4121 and this method will return last row cell address. i.e. $A$65536.
so if I tried to move to next row (Set Range.Offset(2, 0)) then runtime
error will be displayed. Who to resolve this problem? Is there is any
other method to get last filled cell address?

This .Xla file function will be called from VB application.

Thanks
Ved


--
vedpatel
------------------------------------------------------------------------
vedpatel's Profile:
http://www.excelforum.com/member.php...o&userid=31987
View this thread: http://www.excelforum.com/showthread...hreadid=517209