Looking up project invoices

[sidkdbl07]

I have a button in my workbook that when clicked should open another workbook travel to the desired sheet and copy all of the rows with a specified project number into a new workbook.

With the following code, I get a "Compile Error: Object Expected" but I don't know why. Thoughts?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[HaHoBe]

Hi, sidkdbl07,

at which line in the code?

whatīs the value of locateMasterInvoices? You set currentWB but you donīt use it in your code. And shouldnīt you only copy the cells being visible via SpecialCells(xlCellTypeVisible)?

Ciao,
Holger

[sidkdbl07]

Please Login or Register  to view this content.

currentWB could be deleted. You're correct i don't use it anywhere.

I think the error occurs on the following line

Please Login or Register  to view this content.

[HaHoBe]

Hi, sidkdbl07,

my fault - I should have read the code more carefully.

You may Set an object if itīs a workbook, a worksheet, a range, a chart, a shape but you canīt Set a string, only make sure that the variable gets the value by

Please Login or Register  to view this content.

The code is untested still but maybe it can help:

Please Login or Register  to view this content.

Ciao,
Holger