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.
@Chalfie
Yep, that was missing. I had screen updating turned off.
So..
my code (ha..), looks at a csv file (test file approx 6000 records, >100 fields) and
hacks out the columns i don't need
uses autofilter to get rid of records i don't need
looks in a column replaces "this text" with "that text"
looks in another column replaces "this text" with "that text"
loops through the rows replacing "this text" with "that text" by array matching
loops through the rows looking in a column, if cell contains content of another array, delete row
formats text
creates individual worksheets based on unique names in another column, then saves.
i'm sure this could be faster, it took 42 seconds to process 6000 records.
if i replaced the loop and array matching with autofilter, would it be quicker?
should i be happy with what i have?