Recent content by Holly

Hi Paul, Yes, it works of course! Flashy eh? :cool: Thank you so much for helping again. That was a much easier solution! Can you just explain, if you know off the top of your head why the public function method was giving a value of newStreet when it didn't need to be given a value...

Hi Paul, Sorry, I was concentrating so much on the error I have not given you all eventualities. Please see attached new test data with two extra lines added. Some of these include a comma but I still need all of the information, which is why I used iif on the "Small Client..." records. Again...

Hi Paul, I was hoping you'd be around! I think I've attached a spreadsheet with some test data. The red line is the trouble, the other eventualities are OK. If it's unclear let me know! It's stumping me as I don't even want that line to change, it doesn't start with "Small Client...". Thank...

Hi experts, I'm new to VBA so please go easy. I used to post on the site as Holly_Associated but have had to change my user due to a change of job and so cannot upload an example of what I am doing. I shall try to explain below, without writing War & Peace! I am using a public function to feed...