Hello all,
I have a named range that is 800+ rows by 3 columns. There are certain parts of the named range that contain data I need to extract. In the example code below I want to make the "ChassisLF" named range equal to the information from (3,1) to (15,3) in the "Import_Column" named range. How do I properly select the subset?
Private Sub ImportUserFormButton_Click()
Dim wsCM As Worksheet, wsI As Worksheet
Set wsCM = Worksheets("Chassis Measure")
Set wsI = Worksheets("Import")
wsCM.Range("ChassisLF").Value = wsI.Range("Import_Column").Range(.Cells(3, 1), .Cells(15, 3)).Value
End Sub
Bookmarks