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

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

--
herv
-----------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...fo&userid=2731
View this thread: http://www.excelforum.com/showthread.php?threadid=47404

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

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" wrote in
message ...

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

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

Cheers Norman


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=474046