Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Cut and Paste entire row from one worksheet to another

Hello all,
I am attempting to cut and paste an entire row from a change action
from one worksheet to one named "Closed" with the current script:

Public Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Value = "Complete" Then
Target.EntireRow.Cut
Closed.Paste
End If
End Sub

This works but after pasting the row, it throws an error saying target
does not equal anything essentially. Also, this script is embedded in
the worksheet.

Is there any way to fix this?

Any and all help is welcome!

Reply
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



All times are GMT +1. The time now is 08:18 PM.

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

About Us

"It's about Microsoft Excel"