Need help modifying the below code to meet my requirement. Any help would be greatly appreciated. I have 100's of files to convert.
Option Explicit
Sub CreateCIF()
Dim ws As Worksheet
Dim rng As Range
Dim strFileName As String
Dim FF As Long
Dim NoVals As Long
Dim arrVals
Set ws =...