I to populate the data in worksheet from the database from various
sql scripts, I dont know the number of records populated by a query,
but as soon as one query is done other query should populate the
data in next row, so after every query execution i am using this code
{
LastRow = Cells.Find(What:="*", After:=[A1], _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Row

LastRow = LastRow + 1
}
to get the last row. Now for another query i want to pass the
parameter for Range. please suggest what can be used??

This code which i am using is not working:


ThisWorkbook.ImportFromTable(request, name, Sheets(i).Range("B" &
LastRow), xlVertical, False)