Forum

Off for a long time and just now I've tested the codes. Alan Elston and Fluff (Fluffy's macro is working for me now), thank you so much. Both co...

Dear Sir Fluff, .NET Framework 2.0 installed but got the SAME result / problem. For the mean time, I changed the approach and instead used this ...

Thanks, Fluff. But an error here: Set myArrayLst = CreateObject("system.collections.arraylist") Pop-up error: Run-time error '-21462...

Thanks a lot.

Got your point. But my excel file is for distribution (once completed), the reason why I would like to automate things. Plus, as I pointed out, ...

I can't figure out how to manipulate an array. I attached the excel file in my main post which contains the data for reference. 1. Worksheet 1: J2-...

Thanks to Catalin Bombea. I got my problem solved.