counting the rows returned from an SQL Select

[RobAbricon]

I would like to generate an excel report whose length will vary depending on the amount of data rows that I pull back from an SQL Select statement. I would like to limit the number of SQL statements I issue, so would prefer not to send a second query using the count(*) function. Does excel know which row was the last populated after the data has been received? Or is there a more elegant way of doing this?

Any help appreciated

Rob

 

[erik.van.geit]

Hi, RobAbricon
Welcome to the Board !!!!!

to find the last row on a sheet, you can use

LastRow = Cells.Find("*", [A1], xlFormulas, xlPart, xlByRows, xlPrevious, False, False).Row

kind regards,
Erik

 

[RobAbricon]

You star! Works like a dream, didn't even have time to wait for the kettle to boil before your reply came in!

 

[erik.van.geit]

you're WELCOME !!

enjoy the board
a search (see link top of page) for "lastrow" will return plenty of other examples