Hi All, I have a list of formulas (the same) in column D. From D1 to D20
What I want to happen, is when a cell in column D shows value 1 - to move to the corresponding cell in column A (3 cells to the left) and type "STOP".
Please advise how I can go about doing this
And drag down...
Please Login or Register to view this content.
However, something tells me this problem isn't as sumple as it seems.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Sorry, I wanted to do it via VBA.
Basically find the first cell in D1 - D20 with value 1, then (say this is in D6) move to A6 and type "STOP".
If there are no instances of 1 appearing, no action should take place
Sorry about that, maybe cross posting to the VBA subforrum will give this some more attention. Good luck!
Just a heads-up, the forum frowns on cross-posting. If needed, we can move the thread for you, but if you cross-post, it will be closed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok, please move the post then which will hopefully provide an answer.
In essence, I am looking for VBA code to find any cells with value 1 in column D, then move to the corresponding cell in column A - and entering STOP in that cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks