VBA snippet copy and dump

Set wbOpen = ActiveWorkbook

wbOpen.Worksheets(1).Range(“A1:Q5000”).Copy ThisWorkbook.Worksheets(“dump”).Range(“A1”)

wbOpen.Close

Leave a Reply

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

five − 4 =