This is on a worksheet. I am using a command button to select (I'm trying to select!) a range on another worksheet and paste it onto the worksheet where the command button is.
THIS works:
THESE do NOT:
the code works for selecting and copying a single cell, but not for a range.
THIS works:
Code:
ActiveWorkbook.Worksheets("Seatex Incident Log").Cells(18, 6).Select
Selection.Copy
THESE do NOT:
Code:
ActiveWorkbook.Worksheets("Seatex Incident Log").Cells(18, 18), Cells(707, 18).Select
Selection.Copy
Code:
ActiveWorkbook.Worksheets("Seatex Incident Log").Range(Cells(18, 18), Cells(rCol, 18)).Select