$$Excel-Macros$$ Re: Introduce Yourself !!

Hi all, This is Rakesh here, I am chartered accountant by profession, next target for me is to train myself in Macro and VBA. Request experts to send me easy way of understanding and learning Macro and VBA. Regards, CA Rakesh B Jain On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain

$$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

Hi team, is there any piece of code for opening chart object and edit the content in PPT? -- Thanks & regards Satheesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Re: Help required on making pivot caches / tables

Hi All, I am trying to make pivot table using VBA.but I am getting runtime error 5 or so. Can someone suggest me a code to make pivot cache and then table. Thanks Abhishek Bhalla From: amar takaleamartak...@gmail.com Sent:Thu, 25 Feb 2016 10:20:12 +0530 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ If formula Required

Dear Paul Sir Please accept my apologies (G10 & G11 Cell). I had made an error on my part in accidentally.And Overall formula is perfect as per mind.And this is sumif formula & put in subject If formula also apologies for that. Thanks again. Regards Amar On Wed, Feb 24, 2016 at 7:29 PM, Paul

$$Excel-Macros$$ PasteSpecial method of Range class failed error

Hi all, I'm getting error for my code. Can anyone help me analyze where is the error? Thanks in advance. Sub getnew() Dim Sheet1 As Worksheet Dim Sheet3 As Worksheet Dim lastrow As Long Dim i As Long Dim erow As Long Application.ScreenUpdating = False Application.DisplayStatusBar = False

Re: $$Excel-Macros$$ Search and Data Formating help....

I'm sorry, I STILL do not understand. How does the value in column "J" determine the value to display in column "O"? as for "empty" rows.How can a row be empty if it has a value or something in it?If it has something in it, it is not empty.If it is empty, it doesn't have anything in it!? I

Re: $$Excel-Macros$$ Search and Data Formating help....

I am using 2010 excel. I have attached a file. The value in column J will determine what will go into o. So I don't have the value for column o stored any where. what I mean by delete row. Is to clean up the rows after the last row with data. Sometimes some rows might be empty but have in

$$Excel-Macros$$ Client in San Francisco, CA need Ruby Developer---Must have LinkedIn

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Ruby Developer--** Must have LinkedIn* *Duration: 5 months * *Location: San Francisco, CA* Candidate *Qualifications* ü 3+ years of experience with developing full stack web applications in

Re: $$Excel-Macros$$ If formula Required

You keep mentioning an "IF" formula, but I don't see one.I'm not sure what  "test" you're expecting for an "if" formula.It looks like you're trying to simply add the values in the two columns (C and D)for each of the values in column B. This can be done with the Sumif() function. See attached.

Re: $$Excel-Macros$$ Re: overflow error issue

Hi Integer has as limit 32767 more than it it will show overflow error so you have to use long variable.  ThanksRavinder Negi On Wednesday, February 24, 2016 1:11 PM, Kat wrote: Hi Mandeep, I don't know how to use VLookUp function for my situation. I was

Re: $$Excel-Macros$$ If formula Required

Dear Paul Sir thanks very much for this, but if there are another (column criteria) add in formula then how to modified IF formula?. Pls check sheet for sample Regrads Amar On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner wrote: > In cell G4, enter formula: >