Re: $$Excel-Macros$$ Re: Getting Run time error for macro

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

$$Excel-Macros$$ Re: Getting Run time error for macro

> > 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

Re: $$Excel-Macros$$ Re: Getting Run time error for macro

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

Re: $$Excel-Macros$$ Re: Getting Run time error for macro

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