You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
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.
aggi
@Chalfie
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".