$$Excel-Macros$$ Delete row if the next row is same

Hi I have a list of around 20 emails but there 4 to 5 thousand emails which are repeated. Please tell me a macro which can delete the repeated row. Thanks -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Need of VBA

great answer On Tue, Mar 9, 2010 at 12:02 AM, Paul Schreiner wrote: > If I follow your question correctly, you're asking: "why would I need > vba?" > > the answer is directly related to time, and repetition. > > At our location, we had an employee that spent 2 MONTHS gathering and > organizing d

$$Excel-Macros$$ excel vba macro to populate listbox

Hi, Please be patient. I am a newbie. 1). I would like to populate a listbox with a list of 24 months starting with the current month. Need some help. I'd like to do something where I get the month date of the current month. And have a for loop for the next 24 months. 2). Next, I would like t

Re: $$Excel-Macros$$ How to clear clipboard effectively?

Hi Shyam, Thank you for your help. I used similar code to disable the copy/cut/ paste on the key combination and on the toolbar and right click. It works well. However, when one has the clipboard pane opened, one can still copy and paste using the command in the pane. When I used 2003, I can p

Re: $$Excel-Macros$$ How to clear clipboard effectively?

Hi Shyam, Thank you for your help. I used similar code to disable the copy/cut/ paste on the key combination and on the toolbar and right click. It works well. However, when one has the clipboard pane opened, one can still copy and paste using the command in the pane. When I used 2003, I can p

$$Excel-Macros$$ Create a chart only if data is in column

I am looking for a way to to create a macro that will create a chart only if I have data in a specific column. I don't think what I am looking for is an interactive chart that plots only data in a named range but rather I need to have the chart created based on looking at a column and if their is d

Re: $$Excel-Macros$$ Shell Object

Resources For more information, stay tuned to the Visual Basic Team Blog ( http://blogs.msdn.com/vbteam) and the Visual Basic Developer Center ( http://msdn.com/vbasic). If you have specific feedback you’d like to provide you can send it to vbasi...@microsoft.com (VB Team Blog alias). This white

Re: $$Excel-Macros$$ Excel Index Query

You're welcome. On Tue, Mar 9, 2010 at 11:17 AM, wrote: > Thanx Abhishek. > > > > *From:* Abhishek Jain [mailto:abhishek@gmail.com] > *Sent:* Monday, March 08, 2010 7:13 PM > *To:* excel-macros@googlegroups.com; Sarfraj Malek > *Subject:* Re: $$Excel-Macros$$ Excel Index Query > > > > Hi M