quot;, Type:=8)
>
>
>
> For Each cel In RNG
>
> temp = cel.Value
> cel.Offset(0, 1) = "welcome" & vbTab & temp
>
> Next cel
> End Sub
>
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
>
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
>
> On Mon, Feb 24, 2014 at 3:13 PM, Anu Gupta
> > wrote:
>
>>
>>
>> Hi
>>
>> i need to add a static text in all cells of a column ...can any one
Hi
i need to add a static text in all cells of a column ...can any one suggest
how to do this
i try this but not working
Sub try()
Dim temp As String
temp = Cells(1, 2).Value
Cells(1, 2).Value = "welcome" & temp
End Sub
Thanks in advance
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
