Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|