Hi,
I'm trying to get this code to work, but can't figure out what's wrong with it. I'm trying to number rows on column A (starting on A2), based on how many rows have content on column B. I tried the codes below using both Excel 2010 & 2016, but nothing happens. No error message, no numbers entered.
What am I missing? Is there a better option rather than using Autofill?
Thanks for any help!
Please Login or Register to view this content.
I think you would do better to upload a small sample of what you have - and what you want
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
Hello axtryo,
Use the Code below;
Regards.Please Login or Register to view this content.
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] .
Hi axtryo,
If you prefer to see values only, then please use the Code below;
Regards.Please Login or Register to view this content.
Last edited by Winon; 03-06-2017 at 10:07 AM. Reason: Changed Code
Another:
Please Login or Register to view this content.
@ JOHN H. DAVIS,
Why do you count Blank Cells in Column B?
Man, if I get hold of you!
Kind Regards.
@ Winon. Oops.
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 03-06-2017 at 12:40 PM.
@ JOHN H. DAVIS,
Almost there Dear John,
To avoid a dear johnny letter, please ensure your Code provides a logical numerical sequence. For instance, with Cells 8 and 9 in Column B being empty, the next value in Column A should be 8 and not 10.
I like your Loop approach, but before I award you with any points, I would like to see how you come up with a magical "Fix".LOL
Thank you my friend.
@ Winon: Post No. 7 was edited, does it not accomplish what you mention in Post No.8?
@ JOHN H. DAVIS,
Hi John,
Sorry, no, I did not see your edited Code.
Absolutely Brilliant! You Passed with flying colors!
Well done my Friend.
Kind Regards.
Hi axtryo,
JOHN H. DAVIS came up with an excellent piece of Code, and I have put it all together for you in the attached "Automated" sample Workbook.
Column A will update automatically if you add or delete any Data in Column B.
Please say thank you to John for his great contribution.
Regards.
Well,
Winon and John Davis ... Saying 'thanks' sounds way short of the gratitude I feel. For people like me who only have a basic understanding of VBA, having other like you both offering help, goes beyond a simple thanks. Yet, I really appreciate the time you both invested in helping me solve this issue.
You both made my day!
Hello
I know that this is solved but this is my try
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi axtryo,
I have revised the sample Workbook in Post# 11, to work much better.
Please see the attachment.
Regards.
Hi all,
Thank you so much for helping me solve this. Since I got the code working, I'm now marking this post as solved.
Thanks again!
You are welcome axryo, glad we could help.
Thanks for the "Rep", Much appreciated.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks