LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Cut and Paste Error

My program is searching for a row that has the following
characteristics. When it finds the row, it pastes the
row into the third line. However, if the row was already
in the third line, I get an error. The problem is that I
have no idea where the line is going to show up, so I
can't just start at the forth line. Thank you.

i=3
For n = 3 To FinalRow
If Not ((Range("A" & n).Value) = "") And (Range("B" &
n).Value) = 1 Then
Rows(n & ":" & n).Cut
Rows(i & ":" & i).Insert Shift:=xlDown
End If
Next n
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Value Error [email protected] Excel Discussion (Misc queries) 0 April 5th 10 01:21 AM
Paste error Alan[_9_] Excel Discussion (Misc queries) 0 December 17th 07 04:43 PM
Paste value error PJG Excel Discussion (Misc queries) 1 November 24th 06 02:07 PM
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) Tim[_36_] Excel Programming 4 April 23rd 04 02:53 AM
Paste Error Marishah Warren Excel Programming 1 December 17th 03 08:31 AM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"