ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cut and Paste entire row from one worksheet to another (https://www.excelbanter.com/excel-worksheet-functions/114340-cut-paste-entire-row-one-worksheet-another.html)

[email protected]

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!



All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com