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 range 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.
Herve

[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
'<<============

---
Regards,
Norman



"herve" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
> in sheet1, I would like to add text in cells in Column C from a range
> 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.
> Herve
>
>
> --
> herve
> ------------------------------------------------------------------------
> herve's Profile:
> http://www.excelforum.com/member.php...o&userid=27314
> View this thread: http://www.excelforum.com/showthread...hreadid=474046
>

[herve]

Cheers Norman