Using Variables In Filter Params

**bobgodfrey** · 03-23-2017, 02:01 PM

I am attempting to filter my worksheet with VBA syntax and my d2 variable anytime I hover over it is always showing blank and the filter is not applieying appropriately. Is this the correct hyphenation & punctuation to do this?

Please Login or Register  to view this content.

**Bernie Deitrick** · 03-23-2017, 03:19 PM

Please Login or Register  to view this content.

**bobgodfrey** · 03-23-2017, 03:24 PM

If I leave in the CDBL(d1) I get a type mismatch error - if I remove the CDBL(d1) it does not filter correctly. It filters to nothing, like an error occurred.

I have the variables declared as string

Please Login or Register  to view this content.

I also tried to convert the string to a date by using CDate(d1) but that filters nothing like an error

**Bernie Deitrick** · 03-23-2017, 03:41 PM

If you use strings and not dates (not sure why you would do that, but, anyway), then you need to use

CDbl(CDate(string))

Please Login or Register  to view this content.

If you simply want to enter your dates so they look like dates, then use

Please Login or Register  to view this content.

**bobgodfrey** · 03-23-2017, 03:45 PM

That did it, thank you

Using Variables In Filter Params

LinkBack

Thread Tools

Rate This Thread

Display

Using Variables In Filter Params

Re: Using Variables In Filter Params

Re: Using Variables In Filter Params

Re: Using Variables In Filter Params

Re: Using Variables In Filter Params

Thread Information

Users Browsing this Thread

Similar Threads

Loop thru range params - external web connection

Advanced Filter with 'OR' for 2 different variables

how to filter variables among two columns

How to set Application.Calculation = xlCalculationManual from commandline params?

[SOLVED] Opening XLS file directly and getting params

Programmatically pass query params

[SOLVED] Passing Params to Embedded query programmatically

Bookmarks

Bookmarks

Posting Permissions