https://www.excelforum.com/images/icons/icon5.png How to put slash with word and ascending numbers in excel with VBA
Attachment 31495
https://www.excelforum.com/images/icons/icon5.png How to put slash with word and ascending numbers in excel with VBA
Attachment 31495
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 ofCode:Sub 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
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:
Attachment 31496
After running macro:
Attachment 31497
What you said you wanted:
Attachment 31498
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?
I think that was he meant as seen in his example.Quote:
Originally Posted by p45cal
and if you run you code again (accidentally?), the result is different.
Then changeQuote:
Originally Posted by arnelgp
toCode:cll.Value = cll.Value & "/category" & Z
Code:cll.Offset(, 3).Value = cll.Value & "/category" & Z
The numbers not coming as I wanted. Thank youAttachment 31499
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.Quote:
I tested many times before and it was showing incorrectly.