Posts by CSKLC

    Re: VBA, to read a cell contents and use it as a filter

    Thanks for the welcome and thanks for the code, it worked nicely first time. I'm getting back into using Excel and Access after many years break, been discovering how much I've forgotten, looking forward to learning a bit from the forum.

    I have written the code below mostly from key stroke macros. I'm stuck at trying to have the variable "machine" read the contents of the cell $B$4 and use it as a filter. The cell $B$4 is a VLOOKUP from a list. The code in question are the 4 lines from the DIM statement. The rest works fine. Any brilliant suggestions?