$$Excel-Macros$$ Re: Excel blog of the month : Chandoo.org

2011-05-01 Thread anandydr
Hi, I have been regularly visiting this site www.chandoo.org for past couple of years. His comments on various things like dashboarding and charting have been really helpful. Regards, Anand Kumar On May 1, 10:25 pm, Ayush Jain wrote: > Dear group, > > As the part of discussexcel.com initiative,

$$Excel-Macros$$ NEED HELP

2011-05-01 Thread Prathima R
Hi Experts, Due size constance i am sending in two zip folders please check second mail for excel files dump. (This is Second mail please check this one as well -- thanks for cooperation) This report is sent on daily basis please help in this concern if it is automated it could be very much th

Re: $$Excel-Macros$$ "Ring-Fence" macro's copy/paste, so can copy/paste without interference outside the macro

2011-05-01 Thread tomfabtas...@hotmail.com
Thanks PaulS - DDE solved the problem. On Apr 15, 12:30 am, Paul Schreiner wrote: > As Dave suggested, using a copy/paste in a macro is very inefficient. > > using: >     Sheets("Schema").Select >     Range("A1:Z1000").Select >     Range("Z1000").Activate >     Selection.Copy >     Sheets("NewShe

Re: $$Excel-Macros$$ Copy and paste

2011-05-01 Thread Mahesh parab
Hi Bob it would be great if you could provide sample file, you will get solution from other members as well On Sun, May 1, 2011 at 5:32 PM, Bob wrote: > Saying that the copy and paste area are not the same size. But I > changed to same size and still will not work. Thanks for your help!! > Gett

$$Excel-Macros$$ Excel blog of the month : Chandoo.org

2011-05-01 Thread Ayush Jain
Dear group, As the part of discussexcel.com initiative, we declare "Excel bog of the month" each month. This is done to appreciate indvidual Excel bloggers and encourage excel blogging. *Chandoo.org* has been selected as blog of the month for *April 2011*. This is a great excel blog which is very

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - April'11

2011-05-01 Thread NOORAIN ANSARI
Congrate Ashish.. Please keep it continue... On Sun, May 1, 2011 at 10:09 PM, Ayush wrote: > Hello Everyone, > > Ashish Koul has been selected as 'Most Helpful Member' for the month of > April'11 > He has posted 57 posts in April 2011 and helped many people through hi

$$Excel-Macros$$ Ashish Koul : Most Helpful Member - April'11

2011-05-01 Thread Ayush
Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of April'11 He has posted 57 posts in April 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and achieved this recognition from last five months consecu

excel-macros@googlegroups.com

2011-05-01 Thread Prathima R
i am unable to post in groups i uploaded in groups here is the link please find the below link https://docs.google.com/#query/vr?view=0&hidden=1&visibility=1 Hi Experts, This report is sent on daily basis please help in this concern if it is automated it could be very much thankful really

Re: $$Excel-Macros$$ Convert Excel Ranges to PDF

2011-05-01 Thread hanumant shinde
Hi Golden Lance, its amazing. i didnt know we can work like this also. thanks a lot for your input. - Original Message > From: GoldenLance > To: MS EXCEL AND VBA MACROS > Sent: Sat, 30 April, 2011 9:14:51 AM > Subject: Re: $$Excel-Macros$$ Convert Excel Ranges to PDF > > Hanumant,

Re: $$Excel-Macros$$ Copy and paste

2011-05-01 Thread Bob
Saying that the copy and paste area are not the same size. But I changed to same size and still will not work. Thanks for your help!! Getting an error here: Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=FalseOn May 1, 1:49 am, Mahesh parab

Re: $$Excel-Macros$$ Help required in average if - Excell 2003

2011-05-01 Thread jmothilal
OPEN AND RUN THE FILE ANYTHING NEED CONDUCT ME j.mOTHILAL vELLORE On Sun, May 1, 2011 at 2:34 AM, N.Shivkumar wrote: > It is easy in exel2007. Kindly show how the same is to be worked in excel > 2003 > Thanx in advance > > > > N.SHIVKUMAR > Mobile : +919422613567 > Office : +912332301775 > A

Re: $$Excel-Macros$$ Copy and paste

2011-05-01 Thread Mahesh parab
Hi Bob Try Sub copydata() 'Copy contents from Sheet2 Columns A & B Sheets("Sheet2").Select Range("B1").End(xlDown).Select Temp1 = ActiveCell.Address Range("A1" & ":" & Temp1).Select Selection.Copy 'Paste contents on next available blank row on Sheet1 in Columns A & B Sheets("Sheet1").Select Range(