$$Excel-Macros$$ Re: Need Help

The error is : Object variable or with block variable not set Best regards, Ayush jain On Jan 31, 11:11 am, Sunil Thacker wrote: > Whats the error..? > thx > Sunil T > > > > On Sat, Jan 31, 2009 at 1:09 AM, Ayush wrote: > > > I need your help. Do you know how to clear the clipboard of MS Word

$$Excel-Macros$$ Re: Need Help

Whats the error..? thx Sunil T On Sat, Jan 31, 2009 at 1:09 AM, Ayush wrote: > > I need your help. Do you know how to clear the clipboard of MS Word > 2003 through VBA Code? > > If you have any idea, do let me know please. > > > > I have tried this code : Application.CommandBars > ("Clipboard")

$$Excel-Macros$$ Need Help

I need your help. Do you know how to clear the clipboard of MS Word 2003 through VBA Code? If you have any idea, do let me know please. I have tried this code : Application.CommandBars ("Clipboard").FindControl(ID:=3634).Execute But it through an error. Thanks. Ayush Jain --~--~-~

$$Excel-Macros$$ Re: Highlight present week with a border

What i Did: 1) Generated the Dates in Column B. 2) Applied the formula weeknum in Column C =WEEKNUM(B2,1) (To enable weeknum type of function: Tools > Add-Ins > analysis Toolpak ) 3) in $D$2 cell, applied the weeknum for now() 4) Performed the condition format (Formula Is) as mentioned below:

$$Excel-Macros$$ regular expressions

Can you do regular expressions in Excel? I have a bunch of cells that say things like 14" SS and I would like to extract out just the numeric characters and return 14 It would be nice if I could do a regular expression like /[0-9]+/ to get the number out... --~--~-~--~~--

$$Excel-Macros$$ good

--~--~-~--~~~---~--~~ 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 V

$$Excel-Macros$$ Help me to add time to a date and time

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

$$Excel-Macros$$ Re: Highlight present week with a border

Use conditional format.. On Fri, Jan 30, 2009 at 4:07 PM, Ometoon wrote: > > Hello, > > I am trying to highlight the present week with a border. The > weeknumbers are shown in Cell A4:BA4. > A function is used to give a notification FALSE or TRUE if the WEEKNUM > is the same as the current

$$Excel-Macros$$ Re: Highlight present week with a border

Anton , You can do it with Conditional Formatting.. Regards, Vijay Ram On Fri, Jan 30, 2009 at 11:37 AM, Ometoon wrote: > > Hello, > > I am trying to highlight the present week with a border. The > weeknumbers are shown in Cell A4:BA4. > A function is used to give a notification FALSE or TRUE

$$Excel-Macros$$ Re: Highlight present week with a border

I am attaching a Workbook containing a macro (FmtWeekNum) that does what you describe. If you have any questions let me know. Tom On Fri, Jan 30, 2009 at 5:37 AM, Ometoon wrote: > > Hello, > > I am trying to highlight the present week with a border. The > weeknumbers are shown in Cell A4:BA4. >

$$Excel-Macros$$ Highlight present week with a border

Hello, I am trying to highlight the present week with a border. The weeknumbers are shown in Cell A4:BA4. A function is used to give a notification FALSE or TRUE if the WEEKNUM is the same as the current weeknum (based on NOW() Function). I like to built a VBA statement which tells Excel to high

$$Excel-Macros$$ Re: Date Problem

Use the formula in cloumn 3 =IF(A5<>A6,B5,""). Fill it in each row. Then filter column 3 for non-blanks. NB: It will be best if you format the data as a table (or excel list). CA_logo_icai Small1 Anil Kumar Agarwala From: excel-macros@googlegroups.com [mailto:excel-mac...@

$$Excel-Macros$$ Date Problem (Soln. Attched)

HI,   ATTACHED IS A SOLN. TO YOUR PROBLEM. JUST COPY THE FORMULA IN COLUMN 'A' TILL THE END OF YOUR DATA AND THEN REFRESH THE PIVOT TABLE HOPE IT SERVES YOUR PURPOSE REGARDS TEJAS S GANDHI On Thu, 29 Jan 2009 Chaudhry Zahid Ali wrote : >Hi, > >I have got a little problem that I need to solve

$$Excel-Macros$$ Re: Date Problem

Hi,   Could you pls confirm you need the total amount or the amount which is highlighted in your data sheet?   Regards Naveen Kumar M N     Email :naveenkumarmn...@yahoo.com   Best Wishes-Karunaada Kuvara --- On Thu, 1/29/09, Chaudhry Zahid Ali wrote: From: Chaudhry Zahid Ali Subject: $

$$Excel-Macros$$ Re: Date Problem

Hi! Pls chk Attached file Thanks & regards Harish Upadhyay 9773284902 On 1/29/09, Chaudhry Zahid Ali wrote: > > Hi, > > I have got a little problem that I need to solve I have a sheet with > multiple transactions. The columns include Date and amounts. There are > multiple amounts against a

$$Excel-Macros$$ Re: Date Problem

Attached sheet contains the solution, let me know if you are looking for something else Thanks, Nidhesh   On Thu, 29 Jan 2009 Chaudhry Zahid Ali wrote : >Hi, > >I have got a little problem that I need to solve I have a sheet with >multiple transactions. The columns include Date and amo

$$Excel-Macros$$ Re: Date Problem

Hi, Check the attached file let me know if its fine Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Chaudhry Zahid Ali Sent: 29 January 2009 09:17 pm To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date Prob

$$Excel-Macros$$ Re: convert digits into figures

Pls chk attached Add-Ins Thanks & Regards Harish Upadhyay 9773284902 On 1/25/09, sarfaraz ahmed wrote: > > Hello Vikash, > > I think I have achieved what you want and posted the same on my blog. > Kindly visit the link. Though it does not return after decimal. > > > I think mere modification wou