Hi,
I want to select all cells in column B, where the cell in column B has a specified value and the cell in column C has a second specified value without looping.
I was thinking of using the autoFilter combined with specialCells to select the cells, but it didn't seem to work.
thanks.
I want to select all cells in column B, where the cell in column B has a specified value and the cell in column C has a second specified value without looping.
I was thinking of using the autoFilter combined with specialCells to select the cells, but it didn't seem to work.
thanks.