$$Excel-Macros$$ Re: Fwd: Excel Bible 2007, Shortcuts, Functions & More..!

2009-05-15 Thread Manoj S Negi
*Thanks a ton buddy. Its very nice think to share the knowledge with others Cheers.keep this think continue * *Unfeigned Regards Manoj S Negi "Miles & miles to go before I sleep"* *¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`

$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

2009-05-15 Thread Steve
Thank you for the help! On May 15, 1:53 am, bala wrote: > hi > your code process all the sheets listed in list box, check if > List22.Selected (x)  = true then selected value & do the process > > Private Sub CommandButton1_Click() > Dim Lst As String > Dim x As Long >     For x = 0 To ListBox1.L

$$Excel-Macros$$ Fwd: Excel Bible 2007, Shortcuts, Functions & More..!

2009-05-15 Thread Sachin Shukla
Dear All, Please find some excellent books on excel and vba Thanks Sachin Shukla -- Forwarded message -- From: Sachin Shukla Date: Sat, Sep 13, 2008 at 10:41 AM Subject: Fwd: Excel Bible 2007, Shortcuts, Functions & More..! To: Ankit Garg , Neeta , niraj.par...@newriver.com, am

$$Excel-Macros$$ Re: formula in macros

2009-05-15 Thread Habeeb Mohammed
Hi Dave, I got it now... Any way i need to put in a code for dynamically changing the range and can do it Thanks a lot Regards Habeeb From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: formula in macros Date: Fri, 15 May 2009 17:0

$$Excel-Macros$$ Function list in diffrent language

2009-05-15 Thread anderspe
In Swedish version the function have one name, In English it have a new name. Is there a way of telling ef. Swedish version to use English functionnames. och is there a page/tutorial for eg English -> Swedish. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Question about validation

2009-05-15 Thread André
Hello, I use validation to select a value from an area to be inserten in the new location. It works fine, but . . . It takes the value from the source cell instead of a reference. So when I change the value in the source cell the new value that I copied from there with the validated list, does no

$$Excel-Macros$$ Re: automatic Currency conversion

2009-05-15 Thread Surya - Chantigadu
Can you attach a sample file with the require information On Fri, May 15, 2009 at 9:31 AM, Akshay Kadidal wrote: > Hello Experts, > I have a drop down for currency. I want all cells to recalculate when it is > changed and the cells i use are input cellsso i do not need a formula in > there. >

$$Excel-Macros$$ Re: E Book on Excel.

2009-05-15 Thread Surendra saxena
Hi Hari, That is really helping me could you please suggest me a link where i can read MS Access. Regards, Surenda On Mon, May 11, 2009 at 7:30 AM, hari wrote: > Hi Surendra, > > > > FYI. you can check in the site http://www.vbamacros.blogspot.com/ > > > > > > Regards > > Hari Kumar > --

$$Excel-Macros$$ How to stop Excel taking hand on other programs when using an auto refresh VBA code? (Disable window activation)

2009-05-15 Thread EvilButterfly
Hi everyone. I would llike to know how to stop my excel to pop up when I'm working on my computer on other application and I still want my vba code to run. It is very annoying when you lose hand on an another program. I tried to clean my code already (no select) but it still do it (maybe because o

$$Excel-Macros$$ Question about validation

2009-05-15 Thread André
Hello, I use validation to select a value from an area to be inserten in the new location. It works fine, but . . . It takes the value from the source cell instead of a reference. So when I change the value in the source cell the new value that I copied from there with the validated list, does no

$$Excel-Macros$$ Re: formula in macros

2009-05-15 Thread Dave Bonallack
Hi Habeeb, Have a look at the attached, and see if it does what you need. Regards - Dave. From: habeebc...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ formula in macros Date: Fri, 15 May 2009 04:34:26 + Hi Guys, I currently written a code were in total

Fw: $$Excel-Macros$$ formula in macros

2009-05-15 Thread Mudassar Ramzan
Dear Habeeb, Try the following formula. adjust the range as per your data. =SUMIF(A3:A12,"Sub Total",B3:B12) Thanks & regards, || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321 7325277 || - Original Message - From: Habe

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

2009-05-15 Thread anil panchal
this is correct On 5/15/09, JAYAVELU SUN wrote: > > > =COUNTIF(C8:C66,C8) > > this is correct formula > > > jayavelu > > On 5/14/09, Kshitij wrote: > > > > =COUNTIF(C8,C8:C66) > > > > > > > > > > > > > --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

2009-05-15 Thread bala
hi your code process all the sheets listed in list box, check if List22.Selected (x) = true then selected value & do the process Private Sub CommandButton1_Click() Dim Lst As String Dim x As Long For x = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(x) = True Then Lst

$$Excel-Macros$$ formula in macros

2009-05-15 Thread Habeeb Mohammed
Hi Guys, I currently written a code were in total will be populated by adding various sub totals. But I am not able to put in the formula for adding for future reference. I am not able to think a logic for that. I have explained my requirement in the attachement. Please help me

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

2009-05-15 Thread JAYAVELU SUN
=COUNTIF(C8:C66,C8) this is correct formula jayavelu On 5/14/09, Kshitij wrote: > > =COUNTIF(C8,C8:C66) > > > > > --~--~-~--~~~---~--~~ - Some important links for excel users:

$$Excel-Macros$$ automatic Currency conversion

2009-05-15 Thread Akshay Kadidal
Hello Experts, I have a drop down for currency. I want all cells to recalculate when it is changed and the cells i use are input cellsso i do not need a formula in there. is there way we can do itI would appreciateif we could avoid Macros. Akshay --~--~-~--~~~--