excel2000 query

[Gypsy]

I am using a database in Excel 2000 and I wish to record a
macro that copies in another database at the bottom of the
current one. Is there a command which find the last blank
row easily.

 

[Kristofer Gafvert]

Hello,

I suggest that you try the excel newsgroup:

microsoft.public.excel
Or webinterface:
http://www.microsoft.com/office/com...?lang=en&cr=US&dg=microsoft.public.excel.misc

This is maybe also what you are looking for:
http://www.exceltip.com/show_tip/Ot..._cell_in_a_column_in_Microsoft_Excel/400.html

 

[Bob I]

Excel 2000 may only have 65536 rows in a spreadsheet, therefore if row
65536 is blank, IT is the last blank row.