(Solved) – VBA For Loop with Splitting cells

  • by

Excel Masters,

I am attempting to use the SPLIT function in VBA. In column B, I have file names that I need to split everything BEFORE the “_” and put that value in the A column before it.

I am having trouble creating the for loop to accomplish. Also, column B can have any number of rows associated in it, so it’ll need to be a UsedRange function.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *