Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use xldown to select a range of cells | Excel Discussion (Misc queries) | |||
The last filled cell in a range | Excel Discussion (Misc queries) | |||
Count filled colour in cell in given range | Excel Discussion (Misc queries) | |||
Unable to use Range.End(xlDown) method | Excel Programming | |||
Select the next row after xldown range | Excel Programming |