Question How to put slash with word and ascending numbers in excel with VBA

[sam10232321]

How to put slash with word and ascending numbers in excel with VBA

VBA.jpg

[georgiboy]

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/

[sam10232321]

Sorry how can I delete it?

[georgiboy]

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.

[p45cal]

Something along the lines of

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

[sam10232321]

Numbers are coming correctly like shown in my screenshot. Thank you

[sam10232321]

Hi sorry just found out. The numbers are not coming as showing in my screenshot. Possible to fix it. Thanks in advance

[p45cal]

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?

[arnelgp]

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?

I think that was he meant as seen in his example.
and if you run you code again (accidentally?), the result is different.

[p45cal]

I think that was he meant as seen in his example

Then change

cll.Value = cll.Value & "/category" & Z

to

cll.Offset(, 3).Value = cll.Value & "/category" & Z

[sam10232321]

The numbers not coming as I wanted. Thank youvbaz.jpg

[sam10232321]

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.

[arnelgp]

I tested many times before and it was showing incorrectly.

test it again many times, if you are getting wrong result then it is processing by column, then by row.