Hi all,
I have a VBA script that combines data from two different workbooks. This includes a need to change the format of some data, but this part of the script isn't working as expected:
Set extwbk = Workbooks.Open(myLSSource)
Set x = extwbk.Worksheets("Sheet1").Range("$A$2:$O$10000")
Set y =...