On Fri, Mar 26, 2010 at 4:54 AM, <excel-macros+*[email protected] > wrote:*
> Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - Macro <#12797a45393b3903_group_thread_0> [2 Updates] > - VBA Array Statistics (Min, Max, Sum, Avg, StdDev, > etc)<#12797a45393b3903_group_thread_1>[1 Update] > - VBA VLookup dates <#12797a45393b3903_group_thread_2> [3 Updates] > - Excel Ppt Interface <#12797a45393b3903_group_thread_3> [1 Update] > - Date based Triger for a Macro <#12797a45393b3903_group_thread_4> [1 > Update] > - How to seaprate contents <#12797a45393b3903_group_thread_5> [3 > Updates] > - VBA code to capture System time <#12797a45393b3903_group_thread_6> [1 > Update] > - "Excel 2007 Power Programming with VBA" by John > Walkenbach.<#12797a45393b3903_group_thread_7>[2 Updates] > > Topic: Macro<http://groups.google.com/group/excel-macros/t/457e3275bec0f8> > > Suryaprasad <[email protected]> Mar 25 10:20AM +0530 > ^<#12797a45393b3903_digest_top> > > Hi Sreejith, > > Can we have a Sample File for our reference. > > Thanks > Surya > > more...<http://groups.google.com/group/excel-macros/msg/9fd896a78c268d6c> > > > "sreejith k.s" <[email protected]> Mar 25 07:58PM +0530 > ^<#12797a45393b3903_digest_top> > > Sorry for that > > i have atteched two samle files. > > more...<http://groups.google.com/group/excel-macros/msg/9001206f73c5db5e> > > Topic: VBA Array Statistics (Min, Max, Sum, Avg, StdDev, > etc)<http://groups.google.com/group/excel-macros/t/24187bf8cefd4e52> > > excelCPA <[email protected]> Mar 25 07:26AM -0700 > ^<#12797a45393b3903_digest_top> > > I figured out how to get basic statistical data out of a 1-dimensional > Array in VBA. It is actually pretty simple for 1-dimensional arrays > just using the built-in worksheet functions. > more...<http://groups.google.com/group/excel-macros/msg/60962db01bd962a7> > > Topic: VBA VLookup > dates<http://groups.google.com/group/excel-macros/t/92bab575f349391> > > Dave Bonallack <[email protected]> Mar 25 10:38AM +0800 > ^<#12797a45393b3903_digest_top> > > Hi Andy, > > > > I think I made 'found' a range, when it wasn't. Sorry. > > Try: > > If Not IsError(found) Then > Range("H2:H5").Value = found > Else: Range("H2:H5").ClearContents > End If > > more...<http://groups.google.com/group/excel-macros/msg/6b3b4e6fcf4d5c06> > > > Dave Bonallack <[email protected]> Mar 25 12:47PM +0800 > ^<#12797a45393b3903_digest_top> > > Hi Andy, > > I don't think my last mail will work either. > > I've downloaded your sheet from the link you provided, and I'll give it > some thought, but too busy to do much before the weekend. > more...<http://groups.google.com/group/excel-macros/msg/cf13b1ccecd0d3db> > > > Andy <[email protected]> Mar 25 03:20AM -0700 > ^<#12797a45393b3903_digest_top> > > Dave, > > Appreciate the effort - thanks a lot. > > I started to think of another way around the problem but that's > stumping me as well... > > Sub Test() > Dim lookFor As Range > Dim rng As Range > more...<http://groups.google.com/group/excel-macros/msg/bcb9092138238404> > > Topic: Excel Ppt > Interface<http://groups.google.com/group/excel-macros/t/afed06dd740b2463> > > Prashant Pednekar <[email protected]> Mar 25 02:32PM +0530 > ^<#12797a45393b3903_digest_top> > > Dear All, > > I am having presentation (PPT) of 3 slide. Each slide contains one > excel > sheet. > In last slide will have sum of values of Sheet 1 to 3 (i.e. Slide 1 &2 > ). > > The original file is having > more...<http://groups.google.com/group/excel-macros/msg/f5e60a72f8562278> > > Topic: Date based Triger for a > Macro<http://groups.google.com/group/excel-macros/t/583124fff3eec54f> > > "Sathish Jalendran" <[email protected]> Mar 25 03:24PM +0530 > ^<#12797a45393b3903_digest_top> > > Dear Group, > > > > Is it possible to trigger a macro on a specified date , even if that > excel > file is not opened > > > > Regards > > Sathish Jalendran > > > > > > > The information contained in this > more...<http://groups.google.com/group/excel-macros/msg/5bbbf21a877b0eb3> > > Topic: How to seaprate > contents<http://groups.google.com/group/excel-macros/t/73411d62391d79c1> > > Harpreet Singh Gujral <[email protected]> Mar 25 09:53AM +0530 > ^<#12797a45393b3903_digest_top> > > Hi Group, > > I have a cell that contains more than one email address, the idea is to > seaprate them from one another through a loop. Example: > > Cell A1 has the following contents "[email protected], > more...<http://groups.google.com/group/excel-macros/msg/e0a46edd09d68d18> > > > rf1234 rf1234 <[email protected]> Mar 25 12:57PM +0530 > ^<#12797a45393b3903_digest_top> > > Hello Dear, > Have a look on attached workbook. > > > > > > > > > > > > > > > > Hope it Will Help > Happy to Help > :) > Shyam > > On Thu, Mar 25, 2010 at 9:53 AM, Harpreet Singh Gujral > more...<http://groups.google.com/group/excel-macros/msg/61ed651e271c148d> > > > santosh bahuguna <[email protected]> Mar 25 01:20AM -0800 > ^<#12797a45393b3903_digest_top> > > use text to column in data menu > > On Wed, Mar 24, 2010 at 8:23 PM, Harpreet Singh Gujral < > more...<http://groups.google.com/group/excel-macros/msg/bca253faca27e44d> > > Topic: VBA code to capture System > time<http://groups.google.com/group/excel-macros/t/c983ce46ae7423cb> > > Harpreet Singh Gujral <[email protected]> Mar 24 08:26PM -0700 > ^<#12797a45393b3903_digest_top> > > Hi Paul, > > I had once seen a sheet, which used forms to take input from the user, > Plus: it also use to record the System lock time i.e. it would record > it as breaks automatically. > more...<http://groups.google.com/group/excel-macros/msg/7a3f5b1a5da9e58b> > > Topic: "Excel 2007 Power Programming with VBA" by John > Walkenbach.<http://groups.google.com/group/excel-macros/t/ee2407e6e92c9712> > > rf1234 rf1234 <[email protected]> Mar 25 01:29AM +0530 > ^<#12797a45393b3903_digest_top> > > Dear Nani > Check This Link Out > http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm > > > this link provide the basic vba concept with code. > For the book you mension,i have to look it > more...<http://groups.google.com/group/excel-macros/msg/f07a82f2b43a7096> > > > Jef Gorbach <[email protected]> Mar 24 02:22PM -0700 > ^<#12797a45393b3903_digest_top> > > Two of Ohio's libraries have copies available for interlibrary loan if > your local community lacks it. > more...<http://groups.google.com/group/excel-macros/msg/891ae5df71d2dade> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > To unsubscribe from this group, send email to excel-macros+ > unsubscribegooglegroups.com or reply to this email with the words "REMOVE > ME" as the subject. > -- Rgds, Kishor Parihar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
