I mean, IDEALLY, i'd like to use autofilter on the array i've got in the loop. But you can't do that can you?
this bit: loops through the rows looking in a column, if cell contains content of another array, delete row
is the bit I'm on about. it says "if the cell doesn't contain any of these things, delete the row"
Would it be possible to say "select everything but these things in the array, then delete the visible cells".
Why not autofilter, copy the result to a different place, delete all the source and replace with the copied data.
@aggi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I mean, IDEALLY, i'd like to use autofilter on the array i've got in the loop. But you can't do that can you?
this bit:
loops through the rows looking in a column, if cell contains content of another array, delete row
is the bit I'm on about. it says "if the cell doesn't contain any of these things, delete the row"
Would it be possible to say "select everything but these things in the array, then delete the visible cells".