Hi Friend
pl help me out to replace a macro in all sheets of the same file. Or any
other solution may welcome.
Thanks
Pravin Gunjal
On Oct 22, 2015 1:09 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote:
> Can anyone help me on this issue plz.
> On Oct 21, 2015 3:26 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote:
>
>> Hi Mandeep
>>
>> The code you have replaced in this mail has to be replaced in other
>> sheets also of the same file.. file is attached for your immediate
>> reference.
>>
>> Pl help me out on this.
>>
>> Thanks,
>> Pravin Gunjal.
>>
>> On Oct 20, 2015 4:35 PM, "Mandeep Baluja" <
>>
>>
>> rockerna...@gmail.com> wrote:
>>
>>> Hi Praveen,
>>>
>>> Welcome,I am sorry but Please elaborate your query Modify in what sense
>>> and for all sheets means you have the same code in all sheets what kind of
>>> modification you're looking for whether it is automated or it is manual.
>>>
>>> Regards,
>>> Mandeep Baluja
>>>
>>>
>>>
>>> On Tuesday, October 20, 2015 at 4:20:14 PM UTC+5:30, Pravin Gunjal wrote:
>>>>
>>>> Dear Mandeep
>>>> Thank you so much.. it works fantastic.
>>>>
>>>> Can you tell me one more thing, how to modify the vba code in all
>>>> sheets...
>>>>
>>>> Regards,
>>>> Pravin Gunjal.
>>>> On Oct 20, 2015 2:47 PM, "Mandeep Baluja" <rocke...@gmail.com> wrote:
>>>>
>>>>> check this out !!
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>>>>>
>>>>> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing
>>>>> Then
>>>>> For Each cell In Target
>>>>> If cell.Value <> "" Then
>>>>> cell.Offset(0, 1).Value = Application.UserName
>>>>> End If
>>>>> Next
>>>>> End If
>>>>>
>>>>> End Sub
>>>>>
>>>>> Regards,
>>>>> Mandeep baluja
>>>>> https://www.facebook.com/groups/825221420889809/
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> 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 a topic in the
>>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this topic, visit
>>>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe
>>>>> .
>>>>> To unsubscribe from this group and all its topics, 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/d/optout.
>>>>>
>>>> --
>>> 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 a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe.
>>> To unsubscribe from this group and all its topics, 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/d/optout.
>>>
>>
--
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/d/optout.
