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
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
Last edited by Aussiebear; 05-15-2025 at 10:38 PM.
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.
Reply With Quote
