Can anyone help me on this issue plz.
On Oct 21, 2015 3:26 PM, "Pravin Gunjal" 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,
> P
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:2
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" wrote:
> check this out !!
>
>
>
>
> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>
>
>
> 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
