Hello friends, Hope all is well!
Please help me: I am trying to have a loop, that will:
a. Go through sheet “COLUMN”
b. Through ranges “R2” till there is no more data (empty cells in the R range)
c. And copy the contents of R current active cell and pastes it in X2, and so on.
This way X2 keeps changing till the loop end.
d. If the looped range / active cell equals NO, code go on to the next cell and so on
Thank you so much in advance!
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thanks a lot! But I am having difficulties with your code.
it keeps repeating the same results.
I if you don't mind tried on my own and came up with this matter:
I am stuck below, because ActiveCell.Offset(1, 0).Select
is at X2, not at the R ranges. if that can be fixed I think all will be sorted.
Please Login or Register to view this content.
Last edited by countryfan_nt; 02-13-2017 at 01:02 PM.
Hello countryfan_nt,
Please try:
No loop.Please Login or Register to view this content.
Kind Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
I am so sorry and grateful, but I doubt this will solve the code issue that I am having. You see the loop makes changes to filter of a pivot table, and then is responsible for the TOs in the email sending.
that is why I need a loop. Please look at the last post that I made, there you will see the challenge that I am currently struggling with.
You are welcome.
The problem is by executing this line :
the activecell now become this cell (X2), so that :Please Login or Register to view this content.
will always select cell X3.Please Login or Register to view this content.
You need to use a variable as holder to keep track current pointer on column R, like this :
Please Login or Register to view this content.
Hi countryfan_nt,
Thank you for your reply. howerever, your sample Workbook does not display a Pivot Table, hence the confusion.
Please could you update your attachment sample?
Thank you.
Karedog and Winon! thank you both it worked!
You are welcome, thanks for marking the thread as solved and rep.points.
Regards
Hi countryfan_nt,
You are welcome, glad we could help, and thanks for the Rep.
Kind Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks