xlfiltervalues

Hi Folks, Firstly: all this is for a dynamic table called StockListTable. I have a Column (Header = Owner) containing numbers representing customer numbers (1 to 150 plus 998 and 999). I wish to filter out the following customer numbers---0, 27, 72, 84, 100, 998 and 999---thus leaving all...

Hello, I have tried searching for a solution for my problem within the forums, but have been unsuccessful. I hope that this is not a duplicate thread, but if so, please let me know. I am still pretty new to VBA and hopefully this is not too much of a Rookie question. I am trying to set an...

Hi Guy, Still getting to grips with VBA and I'm wondering if anyone can help me with the below code. Instead of filtering to row 10841, I would like to locate the last row and use this. My data will get higher that 10841 rows and I don't want to have to keep increasing the number. Private Sub...