Re: $$Excel-Macros$$ add a static text in all cells of a column

awesome sir it's is really gonna help me a lot thnx again On Monday, February 24, 2014 4:36:13 PM UTC+5:30, Verma G wrote: > > Try this > > Sub try() > Dim temp As String > Dim RNG As Range > Dim cel As Range > Set RNG = Application.InputBox("Select a range", Type:=8) > > > > For Each cel In RNG

Re: $$Excel-Macros$$ add a static text in all cells of a column

Try this Sub try() Dim temp As String Dim RNG As Range Dim cel As Range Set RNG = Application.InputBox("Select a range", 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

Re: $$Excel-Macros$$ add a static text in all cells of a column

Thnx Verma It is working fine can u help me a little more I want to do it by selecting a range manually (drag and select) instead of giving range in code. can we do it any help will be appreciated On Monday, February 24, 2014 3:24:01 PM UTC+5:30, Verma G wrote: > > Try this > > Sub try() >

Re: $$Excel-Macros$$ add a static text in all cells of a column

Try this Sub try() Dim temp As String For i = 1 To Range("A1:A10").Rows.Count ' change row count as per your requirement temp = Cells(i, 2).Value Cells(i, 2).Value = "welcome" & vbTab & temp Next End Sub Thanks & regards, www.MrExcel4U.com On Mon,

$$Excel-Macros$$ add a static text in all cells of a column

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?