How to put slash with word and ascending numbers in excel with VBA
VBA.jpg
How to put slash with word and ascending numbers in excel with VBA
VBA.jpg
Hi sam10232321,
This has been cross posted, links below.
https://www.mrexcel.com/board/thread.../#post-6173314
https://www.excelforum.com/excel-pro...-with-vba.html
If you plan to cross post then you must show us the link to the other locations. People here help for free and it can be rather disheartening spending time working on something that could already be solved elsewhere.
Worth reading the below about cross posting:
https://excelguru.ca/a-message-to-forum-cross-posters/
Sorry how can I delete it?
You don't need to delete it as I have posted the links, others will now know it has been cross posted and can check if it has been solved on those other sites. I was looking for you to understand why it is unfair to cross post without sharing the links to the other locations. Please read the last link I posted above, it will explain all.
Something along the lines ofSub blah() Z = 1 For Each cll In Range("A1:B21").SpecialCells(xlCellTypeConstants, 3).Cells cll.Value = cll.Value & "/category" & Z Z = Z + 1 Next cll End Sub
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Numbers are coming correctly like shown in my screenshot. Thank you
Hi sorry just found out. The numbers are not coming as showing in my screenshot. Possible to fix it. Thanks in advance
Screenshot to show how it's not working or a workbook please.
Before:
2024-04-10_100058.jpg
After running macro:
2024-04-10_100119.jpg
What you said you wanted:
2024-04-10_100531.jpg
Please show me the differences between the last two.
Or are you telling me you want the results in columns in D & E and not overwriting the data in columns A & B?
Last edited by p45cal; 04-10-2024 at 02:12 AM.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
The numbers not coming as I wanted. Thank youvbaz.jpg
I tested many times before and it was showing incorrectly. Now I tested again and it coming correctly as I wanted. well I am bit shocked how is that possible. Anyway really appreciate your time and helping with this formula. You saved alot of time. Thanks again.
test it again many times, if you are getting wrong result then it is processing by column, then by row.I tested many times before and it was showing incorrectly.