I have Tom, but how can I attach the spreadsheet for you to view ?
On Jan 5, 9:53 pm, "Tom Jeffries" <tjeff...@gmail.com> wrote: > 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- 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 -~----------~----~----~----~------~----~------~--~---
