Search userform function

[Sazza]

Hi Guys,

I am trying unsuccessfully to get a search between 2 dates working on a userform

I have been working with code form another thread

And I am getting error every now and again when I run it

Please Login or Register  to view this content.

sometimes it works and other times I get "Run-time Error '1004' Method 'Range out of object' worksheet failed"

I thought I might be down to a pre existing filter and add a clear filter but it still bombs out on this line

Please Login or Register  to view this content.

the data it is pulling from the 'Transactions Summary' table looks like this

Data_Concat	Date
€10 - Voucher	01/01/15
€50 - Purchase	01/01/16

Can anyone help me please ?

TIA
Sarah

[StephenR]

It's probably that you have not fully qualified all the ranges with sheet references

Please Login or Register  to view this content.

[Greg M]

Hi there,

Try using:

Please Login or Register  to view this content.

Without fully qualified references, "Cells(i, 1)" and "Cells(j, 2)" will be taken as applying to whichever worksheet happens to be active when the macro reaches that point in its execution.


Hope this helps - please let me know how you get on.

Regards,

Greg M (fellow Dubliner )

[Sazza]

Hi Stephen,

Sorry what does that mean - I'm a VBA newbie ?

Oh do you mean put sheets("Sheet_name") before it ?

I have this tho ?

Please Login or Register  to view this content.

I did this

Please Login or Register  to view this content.

and now I have a Runtime error 1004 - Application-defined or object defined error

Tis Chilly out there today

[StephenR]

Sarah - wherever you have a reference to a Range or Cells you need to add a sheet reference (put the sheet name or variable name in front). You have done this in most places but below I have filled in a few gaps

Please Login or Register  to view this content.

[Sazza]

OMG THANK YOU ... I have been trying to get that going for hours ...

P.s did I mention Thanks

[StephenR]

My pleasure.