Cell Reference Problem With Cut and Paste

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy-Paste a Row via a cell reference	=?Utf-8?B?QU1ZIFou?=	Microsoft Excel Programming	4	10th Nov 2005 02:07 AM
Copy and Paste macro needs to paste to a changing cell reference	=?Utf-8?B?bG91bG91?=	Microsoft Excel Programming	0	24th Feb 2005 10:29 AM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.	twister212atop@yahoo.com	Microsoft Excel Worksheet Functions	2	11th Dec 2004 12:05 AM
cut and paste cell reference problems	ssibert	Microsoft Excel Worksheet Functions	2	31st Aug 2004 03:18 PM
Cut and paste without altering cell reference	ski-rdu	Microsoft Excel Worksheet Functions	2	16th Jun 2004 12:18 PM