Selecting Ranges In Excel

[HaydenMB]

Hi,

I have some code written that creates an excel application, formats the page and copies in a recordset from my db which works fine. But now I want to add additional recordset at the bottom of the spreadsheet but I do not know how to do the xlDown function in Access VBA.

As the recorsets I am pasting into the spreadsheet do not have a set number of records I want to go to 3 rows below the previously pasted recordset.

Thanks for the help.

Regards,
Hayden

 

[cheerio]

If ws is an Excel worksheet object and rng is an Excel range object then

Set rng = ws.Range("A65536&quot.End(xlUp).Offset(3, 0)

will set the range object to the cell in column A that is 3 rows below the last used cell in column A.

 

[HaydenMB]

Thanks Cheerio,

that worked great

Hayden