Hi,
I want to run a VBA continuously whenever the worksheet("Name") is changing.
Basically, the logic is very simple, if anything in the worksheet("Name") is changing, copy column W and paste in column X. I attached the code below:
I put it under Sheet1(Name) object, not in the Module 1, but every time I change a value, it returns an error message:
Run-time error '-2147418948(80010108)':
Method "Value" of object 'Range' failed
Any help would be highly appreciated. Thanks in advance
Best,
I want to run a VBA continuously whenever the worksheet("Name") is changing.
Basically, the logic is very simple, if anything in the worksheet("Name") is changing, copy column W and paste in column X. I attached the code below:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("Name").Range("X4:X798").Value = Worksheets("Name").Range("W4:W798").Value
End Sub
I put it under Sheet1(Name) object, not in the Module 1, but every time I change a value, it returns an error message:
Run-time error '-2147418948(80010108)':
Method "Value" of object 'Range' failed
Any help would be highly appreciated. Thanks in advance
Best,