Search results for query: *

Hi Tony, Thanks for this, it's been a great help. Regards Kevin

Skip, This is the bit of code that Tony provided; Criteria = "=" & YourVariable & "*" and I'm now using it like this..... Selection.AutoFilter Field:=2, Criteria1:="=" & partlookup & "*" and this works. My original code was; Selection.AutoFilter Field:=2, Criteria1:=partlookup. I...

Hi Skip, I'm still learning VBA and I couldn't think of the right term which was 'variable', Tony's previous reply has now sorted my existing problem, but I don't understand how the code works. Many thanks for your reply. Kevin

Hi Tony, That's great, problem solved, even if I don't understand what's going on. I can't find any information on using the & in the Help file, where can I find an explanation of the fix please? Many thanks Kevin

Bear with me, this could get long and complicated..... I have two ODBC sheets in the workbook and I have created a 'lookup' from one to the other. By using one field in the first sheet, I assign the cell value to a parameter, I autofilter the second sheet using the pasrameter and copy the...

I'm looking for information on the use of the 'Begins With' autofilter in VBA, the helpfiles do not list anything, and Googling for information hasn't worked (but it did lead me here). Can anyone help?