Unable to use variable as "Field:" setting

[CherryBoy]

Hi,

I have searched high and low for this answer, and i am very sorry if it is located in another thread, but I was not able to find it. My problem is.....

I have a form where I collect a filter and 2 columns. I then filter those 2 columns, take all the rows that match the filter, and copy them to another worksheet.

This work as long as I have a filter on only 1 row, and i hard-code the column number. But, I really need to filter on 2 columns, and I need the user to be able to specify which to 2 columns.

Here is the issue - I get an error whenever I try to use a variable for the column (field). I have tried using string and integer, but same error. Below is the code (look for ***** to see problem area), and thank you in advance for any assistance.

Please Login or Register  to view this content.

[mojo249]

Hi

I think your problem is that you've declared txtField1 and txtField2 but you haven't assigned a value to them.

You've got the line FieldNumber1 = txtField1 but you haven't assigned a value to txtField1.

Dion