Cell Reference Problem With Cut and Paste
 

I would like to cut out some rows that I have identified in the first
spreadsheet, and want to paste them to the second spreadsheet. The problem I
am having is that it does not like the below code. How should I be putting
the variables into the code?

Thanks

Dim AccpacBeg As Range
Dim AccpacEnd As Range
ActiveSheet.Rows(" & AccpacBeg.row & ":" & AccpacEnd.row & ").Cut

Cell Reference Problem With Cut and Paste
 

from
ActiveSheet.Rows(" & AccpacBeg.row & ":" & AccpacEnd.row & ").Cut
to
ActiveSheet.Rows(AccpacBeg.row & ":" & AccpacEnd.row).Cut

"Bob Zimski" wrote:

I would like to cut out some rows that I have identified in the first
spreadsheet, and want to paste them to the second spreadsheet. The problem I
am having is that it does not like the below code. How should I be putting
the variables into the code?

Thanks

Dim AccpacBeg As Range
Dim AccpacEnd As Range
ActiveSheet.Rows(" & AccpacBeg.row & ":" & AccpacEnd.row & ").Cut