Re: $$Excel-Macros$$ Insert row after every unique name

ow a button will appear on the Quick > Access Toolbar. > 14- Click the button and your message box will now show. > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Aamir Shahzad > *Sent:* Monday, April 30, 2012 2:26 PM >

Re: $$Excel-Macros$$ Insert row after every unique name

Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Monday, April 30, 2012 2:26 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Insert row after every unique name thanks Don, can you tell me? if I save this code to .xlam (add in) format then

Re: $$Excel-Macros$$ Insert row after every unique name

thanks Don, can you tell me? if I save this code to .xlam (add in) format then how I recall this macro. Aamir Shahzad On Sat, Apr 28, 2012 at 5:28 PM, dguillett1 wrote: > Use this macro in a macro enabled workbook > > Sub insertrows() > Dim i As Long > On Error Resume Next > For i = Cells(Row

Re: $$Excel-Macros$$ Insert row after every unique name

Use this macro in a macro enabled workbook Sub insertrows() Dim i As Long On Error Resume Next For i = Cells(Rows.Count, "c").End(xlUp).Row To 2 Step -1 If Cells(i, "c") <> Cells(i - 1, "c") Then Rows(i).Insert Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com