I think you can actually do this without a macro, but use Excel formulas instead. I have a calendar that for each quarter, I count the days that are identified with "V" for "vacation day" or "H" for "Half day". then, I use: =COUNTIF($D6:$Z11,"*H")*0.5+COUNTIF($D6:$Z11,"*V") to count the "H's" and "V's". In your case, I'd look for the H's, this would find both H and HD, so then SUBTRACT the "HD's"... like:
=COUNTIF($D6:$Z11,"*H*") - COUNTIF($D6:$Z11,"*HD*")*0.5 Be careful though... Make sure the range you're searching doesn't include the month names. Otherwise, it will pick up the "H" in March (of course, you can always subtract 1 to allow for it) hope this helps. Paul On Jan 5, 5:18 am, Joe <joe.mos...@carbonet.co.uk> wrote: > > I wonder if you can help out an absolute novice when it comes to excel > > macros..... > > My girlfriend has sent me some homework as she has to work today and I am > > at home trying to read up on Excel Macros 2003... > > She needs to be able to look through each of the day cells in her excel > > calendar and whenever the text 'H' or 'HD' (holiday or half day holiday > > appear in any of the cells on any of the 12 monthly rows) to reduce the > > holiday cell count by 1 or 0.5 accordingly. > > I may take quite some time to get this clever and wondered if you could > > help > me with an example.to speed my learning curve and to get me much > > needed > > brownie points with my girl friend- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
