I have this Macro working exactly how I need, except one thing. Currently when I enter a value into cell D2 it executes the macro. I want to make it so that after the macro is executed it deletes the value in cell D2. I'm not sure how or what to add. Any help on this?
Please Login or Register to view this content.
Last edited by JBeaucaire; 06-18-2013 at 07:53 PM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.
Use this at the end:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
One part of your code is confusing. rCell is range A1Originally Posted by brown3218
I have this Macro working exactly how I need, except one thing. Currently when I enter a value into cell D2 it executes the macro. I want to make it so that after the macro is executed it deletes the value in cell D2. I'm not sure how or what to add. Any help on this?
Please Login or Register to view this content.
Then you search all of column A for A1's value. It will always match in row 1 because you're searching for A1's value in column A.
I tried the code and I got a runtime error. This is what I put.
Please Login or Register to view this content.
Last edited by brown3218; 06-18-2013 at 10:01 PM.
============
I fixed your post #1, but you've repeated the same error again, so now it's your turn.
============
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
============
When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.
(link above in the menu bar)
Can you indicate which line of code is erroring when you click on DEBUG?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks