Macro to add text in Cell (in a range of Row)

[herve]

Hello,
in sheet1, I would like to add text in cells in Column C from a rang
of row (by FirstRow to LastRow.

In Cell C11 to C?? (LastRow) i would like to add "U-".
does anyone could help me to perform this ?
Thanks in advance.
Herv

 

[Norman Jones]

Hi Herve,

I assume that your intention is to add "U-" as a prefix to existing text.

Try:
'============>>
Public Sub Tester()
Dim LCell As Range
Dim rng As Range
Dim rCell As Range

Set LCell = Cells(Rows.Count, "C").End(xlUp)
Set rng = Range("C11", LCell)

For Each rCell In rng.Cells
rCell.Value = "U-" & rCell.Value
Next rCell
End Sub
'<<============

 

[herve]

Cheers Norman