$$Excel-Macros$$ **ADD/Multiply/Subtract/Divide two Numbers**

2009-04-24 Thread paresh gugale
Dear Aayush, I am a beginer of Macros and please tell me how to add/subtract/multiply/divide two numbers in macros. Regards Paresh Gugale --~--~-~--~~~---~--~~ - Some important lin

$$Excel-Macros$$ Beginner

2009-04-24 Thread Mahesh
Hi All, I am a beginner in VBA, can any one suggest or provide any good and simple book for beginners. Thanks in advance. -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ - Some i

$$Excel-Macros$$ Re: Macro to send email through Excel

2009-04-24 Thread Upendra Singh
Hi Mahesh, I think below line highlighted in Red is creating problem. Simply remove this line. Sub send(i As Integer) Set myOlApp = CreateObject("Outlook.Application") Set mail = myOlApp.CreateItem(olMailItem) Set attach = mail.Attachments Worksheets(1).Select mail.

$$Excel-Macros$$ pivot table formatting with grouped items

2009-04-24 Thread jimmy
hi, i'm creating histograms using pivot tables. i create my buckets by using the grouping function. before i group, the format of the row is 0.00E-00. i group my data from 0 to 1.5e-11 by 1e-12. once i group it, i lose all my scientific notation. my buckets look like 0.0001-0.000

$$Excel-Macros$$ Re: Macro Help

2009-04-24 Thread Dustin
You guys are awesome. Solved now, since you pointed out there is a second syntax option for specifying a range. Also, Paul. Thanks for that tip about the emails! I agree, as well. I've learned most, if not all, of my VBA from here. I've been at it for about a week so far. =) So,... experience awa

$$Excel-Macros$$ Re: User Defined Function Question

2009-04-24 Thread Jake
Thanks Ashish. I thought it might be something like that but I had actually pinged John Walkenbach about it and he said he's able to see his functions in that pop-up box. In retrospect, I may not have been clear about what I was asking and he was talking about something else. Again, thanks for

$$Excel-Macros$$ Re: Filter Pivots

2009-04-24 Thread Fabio Lemos
Ok, I'he highlighted some parts of the macro: 1. The green part: It's the page field name that you're trying to synchronize. If it`s another fild type you`ll have to change PageFields to the correct field type. 2. The yellow part: Is the value to be filtered, you can change to one variable ou chang

$$Excel-Macros$$ Re: Filter Pivots

2009-04-24 Thread praban99
Hi, Thanks for this. I am a beginner in VBA, can you help me in putting the macro in the sheet, coz i need to change the macro to suit my requirements. Thanks in advance. Regards, Prashanth On Apr 23, 2:34 am, Fabio_XL_Master wrote: > Hi, > > It's possible using macros: > > Public Sub Apli

$$Excel-Macros$$ Re: Excel-Help

2009-04-24 Thread Sathish Jalendran
U can download the Compatibility pack and u can retrieve the data http://office.microsoft.com/en-us/products/HA101686761033.aspx Regards Sathish Jalendran -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of raafi barey Sent: 24 A

$$Excel-Macros$$ Re: Excel-Help

2009-04-24 Thread Paul Schreiner
You're WAY to frugal with your info... "I have a data" ... What FORMAT is the data in? Where are  you getting it from? "is more than the capacity of excel 2002".     Is it because if there is too many rows? or too many columns? I mean, the answer if your file is: a) a text file b) th

$$Excel-Macros$$ Re: Seating Chart

2009-04-24 Thread Paul Schreiner
So... you're wanting us to do your HOMEWORK? From: ronnie To: MS EXCEL AND VBA MACROS Sent: Thursday, April 23, 2009 10:10:26 PM Subject: $$Excel-Macros$$ Seating Chart Your task is to write a small macro that converts the seat list into a seat chart in tabl

$$Excel-Macros$$ Re: Macro Help

2009-04-24 Thread Paul Schreiner
Dustin, it looks like you've had several replies to your question. I tested it, and it looks like Habeeb's answer works just fine (except for needing a couple of spaces: Worksheets("RAW").Range("A3:CE4900").Copy _ Destination:=Worksheets("ExecServices").Range("A" _ & iNextRow & ":CE" & iNextRow) I

$$Excel-Macros$$ Excel-Help

2009-04-24 Thread raafi barey
Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: XML

2009-04-24 Thread santosh bahuguna
Can you please send me the sample data so that i can assist you with actually in this matter we need to be have the DATA and the site url in which you want to upload the data sorry for late reply : regards Santosh Bahuguna On 3/30/09, santosh bahuguna wrote: > > hi satish > > > >If yo