Re: $$Excel-Macros$$ Attention Please

2010-11-04 Thread ashish koul
can u attach excel sheet.. On Fri, Nov 5, 2010 at 11:40 AM, vebhav jain wrote: > > > -- Forwarded message -- > From: vebhav jain > Date: Thu, Nov 4, 2010 at 2:01 PM > Subject: $$Excel-Macros$$ Data Keep Varies > To: excel-macros@googlegroups.com > > > Hi All,

$$Excel-Macros$$ Attention Please

2010-11-04 Thread vebhav jain
-- Forwarded message -- From: vebhav jain Date: Thu, Nov 4, 2010 at 2:01 PM Subject: $$Excel-Macros$$ Data Keep Varies To: excel-macros@googlegroups.com Hi All, With the help of macros, i recorded the whole data. The problem is that data keep varying every day and i have to adju

Re: $$Excel-Macros$$ Wishing you all A Very Happy Diwali...

2010-11-04 Thread Kishan Reddy, K
To all the members & families Happy Deewali Kishan Reddy, K On Nov 4, 8:54 pm, Chandra Shekar wrote: > Hi Ashish, > > WISH U THE SAME > > Thanks > > Chandra Shekar B > > > > On Thu, Nov 4, 2010 at 6:08 PM, ashish koul wrote: > > Wishing you all A Very Happy Diwali... > > > -- > > *Regards* > >

Re: $$Excel-Macros$$ Non-Uniform Random Number Generator

2010-11-04 Thread busboy10
I appreciate the help André but my issue is more complex than a random number between two values. I have a known distribution and would like to select a value randomly based on the probabilities inherent within the distribution. Your solution would work great if i had a uniform distribution betwe

$$Excel-Macros$$ Re: Delete values within an array

2010-11-04 Thread RemyMaza
I ended up fixing this by using a filter on my array: 'ReDim arrDeviceNames() to trim the "EMPTY DEVICE" arrNonEmptyDeviceNames = Filter(arrDeviceNames, "EMPTY DEVICE", False) Thanks guys, Matt On Nov 3, 9:13 am, RemyMaza wrote: > I have an array of values that come in off of a form.  O

Re: $$Excel-Macros$$ Wishing you all A Very Happy Diwali...

2010-11-04 Thread Chandra Shekar
Hi Ashish, WISH U THE SAME Thanks Chandra Shekar B On Thu, Nov 4, 2010 at 6:08 PM, ashish koul wrote: > Wishing you all A Very Happy Diwali... > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com > *akoul*.wordpress.com >

$$Excel-Macros$$ Data Keep Varies

2010-11-04 Thread vebhav jain
Hi All, With the help of macros, i recorded the whole data. The problem is that data keep varying every day and i have to adjust the data manually everyday to run the macros. Please can you suggest better way to take the data, instead of changing manually everyday. Example. Column A has 450 data

$$Excel-Macros$$ Wishing you all A Very Happy Diwali...

2010-11-04 Thread ashish koul
Wishing you all A Very Happy Diwali... -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile P Before printing, think about the environment.

$$Excel-Macros$$ Re: Any body know about How to make vba progress bar please share

2010-11-04 Thread Waldan
Hi, You can use the Microsoft progress bar component presents in the controls tools box. Set the min and max values in its properties then, during your treatment (vba), modify its value to represent the correct progress of your work. Personally, I prefer modifying the status bar in my treatment w