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 wrote
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 @
https://www.facebook.com/discu
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 takale"amartak...@gmail.com
Sent:Thu, 25 Feb 2016 10:20:12 +0530
To: excel-macros@googlegroups.com
Subje
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 Sc
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
Activ
Thanks Paul and Sky!
I love learning this stuff. GLAD to hear Concatenate was a throwback.
That's a pain to try & remember to type.
That Said, on to the next part. This is the formula I'm using:
=IF((A1)<1,"",(IF(LEN(A1)<=5,(("AB"&(TEXT(A1,"0",A1)))
HOWEVER, I want the second IF statem
I am a bit confused with your question.
This is what I am able to come up with so far.
maybe you might be able to understand what I am trying to do from the code.
So I was able to come up with this but it is not placing the value in same
come as the word type
Dim colLast As Long
Dim Rng
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 suspec
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 val
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 *R
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.
al
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 wondering
whether would you m
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:
> =SUMIF(C$4:C4,F4,D$4:D4)
> and copy
13 matches
Mail list logo
