Hi,
I seem to have some type mismatch in my macro...
The error appears every time i insert or delete a row in the worksheet.
This is the code:
Please Login or Register to view this content.
Error is in the line: If Target.Address = "$B$25" And Target.Value <> "" Then
Anyone with a suggestion?
Last edited by royUK; 01-30-2009 at 08:28 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
As this is your first post I will add them, but you must read the forum rules before posting again.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You need to delete this lines,
Please Login or Register to view this content.
That doesn't seem to make any difference.
As it is still pointing out the mismatch in:
Please Login or Register to view this content.
... Funny thing is, the error only appears when I insert of delete a row....
yeahaaa
found a solution...
just cut the errors by disabling the errors like this:
cheerio!Please Login or Register to view this content.
That's not a solution, that's ignoring the errors.
Sorry true.. therefore found another REAL solution:
Added the code:Please Login or Register to view this content.
Because Target.Value is targeted at one cell.Please Login or Register to view this content.
This code prevents that.
Cheerio!
That's better, you must have been selecting several cells.
Yep that's it, when selecting a row on the left side you automatically select multiple cells (all cells horizontal on that row).
So this solution helps indeed.
Thanks for your replies.
Hi, i get the same runtime error in my VBA macro. My code is below. now the funny thing is if I delete "StartInsTime" my code runs, but if I include it i get the runtime error. Any clues on how to resolve this?
Please Login or Register to view this content.
Last edited by dp1; 08-30-2012 at 09:58 PM. Reason: tags
Hello dp1, and welcome to the forum.
Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks