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
>
> temp = cel.Value
> cel.Offset(0, 1) = "welcome" & vbTab & temp
>
> Next cel
> End Sub
>
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
>
> On Mon, Feb 24, 2014 at 4:21 PM, Anu Gupta <anu.r...@gmail.com<javascript:>
> > wrote:
>
>> 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()
>>> 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 <http://mrexcel4u.blogspot.com/>
>>>
>>>
>>> On Mon, Feb 24, 2014 at 3:13 PM, Anu Gupta <anu.r...@gmail.com> wrote:
>>>
>>>>
>>>>
>>>> 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? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros...@googlegroups.com.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros...@googlegroups.com <javascript:>.
>> To post to this group, send email to excel-...@googlegroups.com<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
