Error when using FIND Method to find last row when column is blank

Ive been using the following method to find the last row on multiple sheets that contain web queries. The queries contain lists of stock symbols that i filter and move to a master sheet that i then import to my trading application. They all normally work fine, but some days the queries contain no stocks for the day and i receive... "Run-time error'91': Object variable or With block variable not set". Heres the code.....

Please Login or Register  to view this content.

Ive tried playing around with 'If NOT lastrow is NOTHING then' and ' IF lastrow is NOTHING then' but couldnt get anything to work. Not even sure if that approach would even work with this kind of problem.Was wondering if there was a way to work around this. Any help would be greatly appreciated.

You do not have a "Find function" in your code, what you have is to look for the last row in column D

Please Login or Register  to view this content.

You can change this to look at the last row in your data, not just in column D. For e.g

Please Login or Register  to view this content.

I think there is something from your code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

need to go in a cell. Where is the copied range is going? In which column?

Please Login or Register  to view this content.

if it go in to column A

I need to look for last row in column D. The query that is on the sheet is of the entire web page and theres data everywhere on it. The information i need is on one area right in the middle of the page and its the only data on the page thats ever in that column.

Originally Posted by AB33

You do not have a "Find function" in your code, what you have is to look for the last row in column D

Please Login or Register  to view this content.

You can change this to look at the last row in your data, not just in column D. For e.g

Please Login or Register  to view this content.

Thanks. I took your suggestion and this is what ive got and it works perfect.

Please Login or Register  to view this content.

Originally Posted by Sean Thomas

try using some error handling

Please Login or Register  to view this content.

Im pasting to named ranges on "Import_Ts" sheet.

Please Login or Register  to view this content.

Originally Posted by AB33

I think there is something from your code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

need to go in a cell. Where is the copied range is going? In which column?

Please Login or Register  to view this content.

if it go in to column A