Forgive me if this code looks wonky. I pieced it together knowing very little about coding. What I want it to do is cut all cells with a value greater than 300 from cell range "B2:B71", and then paste those cells into column "I". It pastes them over, but is failing to paste the first cell that meets the value requirement. I think this may be because I have a header in I1. Help?
Please Login or Register to view this content.
TIA
Last edited by Veroshima; 09-02-2017 at 07:34 AM.
3. 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 [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:
... and appear like this when posted:Please Login or Register to view this content.
your code here ...
and here ...
and here
You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Oh, thank you! I will do that.
Should I not start from 2?
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Yes, to start on 2 would be ideal. I don't want to use a specific range, though, like "I2:I40". Just "I2: (however many cells it takes)" Is this possible?
Please Login or Register to view this content.
Last edited by mehmetcik; 09-02-2017 at 10:42 AM.
I am getting a "next without for" error on this.
Last edited by Veroshima; 09-02-2017 at 09:33 AM.
Although I did not get your sub test to work, looking at your code helped me to see what I was doing wrong. Thank you so much for your time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks