Hi All
I am getting a mismatch error when I run this code. Basically I just want to be able to insert a new row and have existing formulas, formatting copied, which works pretty well, but I now get a mismatch error with some other code. How do I resolve this?
This is the error; runtime error 13
Please Login or Register to view this content.
ThanksPlease Login or Register to view this content.
Isacael
With this:
the Worksheet_Change event is forced to trigger again.PHP Code:Then Target.Value = 1
To prevent this, try to turn off the Events, then turn on again after running
PHP Code:Private Sub ...
Application.EnableEvents = False
...main code
Application.EnableEvents = True
End Sub
Quang PT
When you copy in the first macro, the target becomes the entire row (16k columns)
In your CHANGE macro, you need to reset the target to the activecell:
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks