I cannot figure out why, but the below snippet is copying the whole worksheet (except for row 3). I use this same structure throughout the tool I'm building, and don't have this issue, so is there something I should look at on the source file (sD)? 'Populates the Account column. With sD.Range("B2:B" & sDLR).SpecialCells(xlCellTypeVisible).Copy mD.Range("G" & mDLR + 1).PasteSpecial xlPasteValues End With • A message box shows that B2 is being read properly. • sDLR is returning the correct last row (2)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Whole Worksheet being Copied Instead of Desired Range

Thread starter reberryjr
Start date Dec 12, 2023

reberryjr

Well-known Member

Dec 12, 2023

I cannot figure out why, but the below snippet is copying the whole worksheet (except for row 3). I use this same structure throughout the tool I'm building, and don't have this issue, so is there something I should look at on the source file (sD)?

VBA Code:

    'Populates the Account column.
    With sD.Range("B2:B" & sDLR).SpecialCells(xlCellTypeVisible).Copy
        mD.Range("G" & mDLR + 1).PasteSpecial xlPasteValues
    End With

• A message box shows that B2 is being read properly.
• sDLR is returning the correct last row (2)