Re: $$Excel-Macros$$ copy macro error

try this Sub Datacopy() Sheets(teste).Range(Sheets(teste).Cells(1, 1), Sheets(teste).Cells(Sheets(teste).Range(a65356).End(xlUp).Row, 3)).Copy With Sheets(destino) .Cells(Sheets(destino).Range(a65356).End(xlUp).Row, 1).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues

Re: $$Excel-Macros$$ Urgent Formula Required Help me

U can Use Mid Function for the same =Mid(Cell Reference, Starting Num, No of Chars) For eg Ur Orignal Code is 8900765 U want 765 then fromula is =mid(cell Ref, 5,3) Hope this will get result as u want. On Apr 1, 6:55 pm, Puttu * puttu...@gmail.com wrote: Can you please please help any one

$$Excel-Macros$$ Need Help Regarding not calculating the average in case of Jan month but for all other month they are showing correct result

Hi in this formula if i am incresing the range 25 to 125 then it is counting blank cell also and traeting blank cell as a jan month so is there any suggestion where can we ignore blank cell =IF(ISERROR(AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125))),,AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125)))

Re: $$Excel-Macros$$ How to send mail with excel

Public olApp As Object Public oNewMail As Object Public FilePath As String Public isthereFileAttach As Boolean Public bd As String Public sb As String Public Sub ONE_ONE(ByVal recipient As String) Set olApp = CreateObject(Outlook.Application) Set oNewMail = olApp.CreateItem(olMailItem)

$$Excel-Macros$$ ANSI file

Is it possible in any version of excel to save text file as ANSI encode instead of Unicode regards, Farhan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

Congrats Ashish..Keep it up On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of March'11 He has posted 48 posts in March 2011 and helped many people through his expertise. He has

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

Congrats Ashish!! Keep up the good work!! Cheers Andy On Wed, Apr 6, 2011 at 3:21 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congrats Ashish..Keep it up On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most

$$Excel-Macros$$ Run - Copy / Paste - Repeat Macro

Hi, I have this great Monte Carlo Simulation program for blackjack. I am not all that good in VBA, but would like a small macro to run this program, the copy and paste the results to another sheet, then repeat that task again for as many times as I wish. Any takers ? I can forward the

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

Ashish is really very good in VBA Programming and He want to help people by Using his excellent knowledge of Excel VBA, Good Going Bro... keep it Up. Rajan On Mon, Apr 4, 2011 at 5:01 PM, Raghunandan raghunandan...@gmail.comwrote: Gr8 goin On Mon, Apr 4, 2011 at 10:25 AM, mrinal saha

Re: $$Excel-Macros$$ copy macro error

Ohh thank you very much :) 2011/4/6 ashish koul koul.ash...@gmail.com try this Sub Datacopy() Sheets(teste).Range(Sheets(teste).Cells(1, 1), Sheets(teste).Cells(Sheets(teste).Range(a65356).End(xlUp).Row, 3)).Copy With Sheets(destino)

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

Congratulations Ashish especially for your help and also to this forum, i have to say my learnings in macro are exponential since this was created, i was a zero at the beginning! 2011/4/6 Aindril De aind...@gmail.com Congrats Ashish!! Keep up the good work!! Cheers Andy On Wed, Apr 6, 2011

$$Excel-Macros$$ How to make excel addins

Hi Friends, I have made some macros for some purpose and i want to use that in my all the excels. i got information from the net that is i change the extension of file to xla and put in addin folder then it will work. But its giving error that the file is not in proper fomat. Pls help me on

$$Excel-Macros$$ Re: How to make excel addins

You might be using a 2007+ Excel file. Try using the extension .xlam On Apr 6, 6:01 pm, Deepak Rawat deepakexce...@gmail.com wrote: Hi Friends, I have made some macros for some purpose and i want to use that in my all the excels. i got information from the net that is i change the extension

$$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

try this On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar harkesh.kuma...@gmail.comwrote: Hi Experts, We required your help for creat auto mailer in excel. or any other way, I have to send 200 mails with different attachment. can we creat auto mailer in excel thourgh macros. Please help me

Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro

Yes, you are on the right track. However, I am looking for more of an automated loop with an option to prompt me as to how many repititions to be made. I would probably want to run thousands. After making this request, I noticed that here appears to be something suspiciously wrong with the random

Re: $$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

HI Ashish, Its helping but i dont want to create pivot every time. i want to remove this manual effort. Can you please share some macro i can enhance that. please send me some macro. when i press the button for SV. it has to calculate SV into three sheets. Please help me on this. Regards,

Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

Its awesome.Hats off to Ashish. Regards, C.G.Kumar On Thu, Apr 7, 2011 at 10:35 AM, ashish koul koul.ash...@gmail.com wrote: try this On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar harkesh.kuma...@gmail.comwrote: Hi Experts, We required your help for creat auto mailer in excel. or any