Avatar of yop6

asked on 

Creating Named Ranges in Excel Worksheet for columns A:O

I'm using a loop to loop through 100+ workbooks to push Qrys to respective files. A new query was added and I want to create a named range within the loop for each individual file one the same worksheet in reference to the same columns

I have a string variable set for each file path "PATHx"

The worksheets are name "xwalk"

The number of rows in each query varies but the data need to be dropped in columns A:O without headers from starting in  A1
Microsoft AccessOffice ProductivityMicrosoft ExcelVB Script

Avatar of undefined
Last Comment

8/22/2022 - Mon