heedaf
03-07-2019, 01:27 PM
I'm trying to figure out how to basically do the following theory:
dim Rng as range
dim FiltRng as range
set Rng = Worksheets("Sheet1").Range("C16:C51")
set FiltRng = filter(Rng, "a")
Where the Rng now contains all cells that have an "a" contained in it. I'm able to do this with an array but I would really like to retain the details of the original cell.
dim Rng as range
dim FiltRng as range
set Rng = Worksheets("Sheet1").Range("C16:C51")
set FiltRng = filter(Rng, "a")
Where the Rng now contains all cells that have an "a" contained in it. I'm able to do this with an array but I would really like to retain the details of the original cell.