Do you have an example of the Calendar? Describe its format in more detail.
On Mon, Jan 5, 2009 at 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 > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
