Re: $$Excel-Macros$$ Problems with Add-ins

2010-02-28 Thread yogananda muthaiah
Hi, its working fine . wats the add-in name u have selected. lets us know to solve ur query On Mon, Mar 1, 2010 at 12:05 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > I am facing a problem while this add-in loads on excel open. The error > message reads as follow

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-28 Thread Mark Kim
Hi, Thanks for the code. But I tried but it doesn’t seem to work as expected. Can I ask you this please? in the data sheet you uploaded, what I want is to select Dat1 to Data 7 and remove blank rows. In my real data I work with, there are 6 rows between the last transaction record and FBT detail

RE: $$Excel-Macros$$ Data in variables

2010-02-28 Thread Dave Bonallack
Hi, Two ways I know of: Public A As ... as opposed to: Dim A As .. The 'Public' statement goes in any module, but outside any sub. The value of the variable will be available while the workbook remains open, but will be lost when the workbook closes. The other way is to store the variable

Re: $$Excel-Macros$$ How to select unique values from a list and copy each unique value to another location of another worksheet

2010-02-28 Thread OSAVentures Calamba
Thanks to all the great suggestions provided. On Fri, Feb 26, 2010 at 7:36 PM, Dave Bonallack wrote: > Hi OSAVentures, > > Have a look at the attached to see if you can adapt it to your own needs. > > Regards - Dave.* > * > -- > Date: Fri, 26 Feb 2010 14:53:14 +0800 >

$$Excel-Macros$$ Data in variables

2010-02-28 Thread Harpreet Singh Gujral
Hi, Is it possible to keep the value stored in the variable till the time the sheet is running or the code is running. Example: I have to a variable A and B, which i need to use to store information from a form, this information will be used in other modules or procedures. Is it possbile to keep

$$Excel-Macros$$ Shell Object

2010-02-28 Thread Harpreet Singh Gujral
Hi Group, Some of the VBA Macros use shell object in their codes. Can somebody help me understand what is it all about? Thanks Harpreet Gujral -- -- Some important links for excel users: 1. Follow us on TWITTER fo

$$Excel-Macros$$ Excel Daily Tip : Filter by the Selected Cell

2010-02-28 Thread Ayush Jain
Ayush Jain has sent you a link to a blog: Dear Excel Enthusiasts, Here is a Excel 2007 Tip about Filtering. Please keep sharing tips and tricks in group. Thanks. Best regards, Ayush Jain Blog: Excel Daily Tip Post: Filter by the Selected Cell Link: http://exceldailytip.blogspot.com/2010/02/filter