vba named range link file

  1. R

    VBA for copying remote data

    Hello, I have a macro that references a defined-name-range to another file (e.g. CopyFrom_Range ='[some_file.xls]Sheet1'!$A$2:$B$33) The macro cycles thru the cells of the defined-range with: For Each c In Range("CopyFrom_Range"). This works as long as the SOME_FILE.XLS is...

Some videos you may like

This Week's Hot Topics