Cell Reference Problem With Cut and Paste

B

Bob Zimski

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
 
J

Joel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to cut a paragraph that's followed by a table 2
cut/paste columns efficiency 13
Pasting a cell into bookmarked table from excel vba 1
Paste failing after cut 8
Cut and Paste 4
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to paste the same cell one tab over 1
this code is VERY slow, is it the code or perhaps a worksheet issue 32

Top