$$Excel-Macros$$ Re: Help me !!!
Ctrl +D try this site http://www.asap-utilities.com/excel-tips-shortcuts.php Y On Feb 1, 4:26 pm, Ajay Kumar ajay.trivand...@gmail.com wrote: The fill handle is very helpful for filling cells with various values. However, I much prefer to use the keyboard in preference to the mouse. Is it possible to utilize the fill handle in some way only by using the keyboard? aJaY :) (R)™ --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help me to add time to a date and time
put now() and in other cell input the number of hours in the same format and then add the two cells. On Fri, Jan 30, 2009 at 8:38 AM, Muthu psgmu...@gmail.com wrote: I will explain my problem with an example. 30/01/2009 13:30 is the time.I want to add 36 hrs to it. But I should add it only during the working hours.(8:30 hours per hour a day(exclude week ends and holidays)). Assume working time to be from 08:00 to 16:30 So the time after 36hrs added would be 05/02/2009 16:00. I can add only the date through workday function,which also excludes holidays and weekends.But I am not able to add the exact time. Can YOU help me to get it done through macros?? Thanks in Advance -- Hari kumar --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help me !!!
ALT + E + I + S On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar ajay.trivand...@gmail.comwrote: The fill handle is very helpful for filling cells with various values. However, I much prefer to use the keyboard in preference to the mouse. Is it possible to utilize the fill handle in some way only by using the keyboard? aJaY :) (R)™ --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
$$Excel-Macros$$ Selective copy of non bank cell
HiI hv a xl sheet whre i want to copy one of the column which contains both blank non blank cells). but I want copying only non blank cells(cells having data) from that column. Could somebody help me in writing a macro for this. Regards Debasish Sahu Assistant Manager - Geology ACC Ltd. Thane - 400 604 India --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help me !!!
Select edit insert fill series ( step 1 ) option On Sun, Feb 1, 2009 at 5:21 AM, yorkeyite yorkeyi...@gmail.com wrote: Ctrl +D try this site http://www.asap-utilities.com/excel-tips-shortcuts.php Y On Feb 1, 4:26 pm, Ajay Kumar ajay.trivand...@gmail.com wrote: The fill handle is very helpful for filling cells with various values. However, I much prefer to use the keyboard in preference to the mouse. Is it possible to utilize the fill handle in some way only by using the keyboard? aJaY :) (R)™ -- Hari kumar --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---