# Posts by kpmsivaprakasam2003

• ## IF and Max Formula through VBA

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

IF and Max Formula through VBA
I am using Excel 2013 I have applied the VBA formula but not return the results Below formula: =IF(ISNUMBER(I6),IF(VALUE(I6)=\$L\$6,MAX(\$H\$6:\$H\$79),NA()),NA())…
stackoverflow.com

IF and Max Formula through VBA
Hi, I am using Excel 2013 I have applied the VBA formula but not return the results Below formula:…
chandoo.org

IF and Max Formula through VBA
Hi, I am using Excel 2013 I have applied the VBA formula but not return the results Below formula:…
www.mrexcel.com

Hi, I am using Excel 2013

I have applied the VBA formula but not return the results
Below formula:
=IF(ISNUMBER(I6),IF(VALUE(I6)=\$L\$6,MAX(\$H\$6:\$H\$79),NA()),NA())

Code
``````Dim MyRange As Range
Set MyRange = Range("D5").Offset(1, 1 + 3).Resize(m + 1, 1)
Range("D5").Offset(1, 1 + 6).Formula = "=IF(ISNUMBER(" & Range("D5").Offset(1, 1 + 4).Address(0, 0) & ",IF(VALUE(" & Range("D5").Offset(1, 1 + 4).Address(0, 0) & "=" & Range("D5").Offset(1, 3 + 5).Address(1, 1) & ",MAX(" & MyRange.Address & "),NA()),NA())"``````

• ## Excel to PowerPoint Paste with Keep Source Formatting

Hi i am using the excel 2013

I activated the excel and PowerPoint with 2 nos empty slides

Sheets "1" and "2" data range copy and paste to PowerPoint

this code paste with image, I need Paste with "Keep Source Formatting"

'Paste to PowerPoint and position

On Error Resume Next

Set shp = myPresentation.Slides(MySlideArray(x)).Shapes.PasteSpecial(DataType:=2) 'Excel 2007-2010

On Error GoTo 0

• ## Change Order For Chart Series Collection VBA Code

Hi

I am using the Excel 2013

I have to change in select data the Specify Order For Series collection in Select Data for Chart

=SERIES([Series Name],[X Values],[Y Values],[Plot Order])

I have to change the "Holder" series collection from 5th to 1st move

I actually did something similar. I put "ActiveChart.SeriesCollection(5).PlotOrder = 1" for the first data series, but it doesn't work that way.

when i run the vba code "ActiveChart.SeriesCollection(5).PlotOrder = 1", but this go 3rd position the "Holder".

I don't know, what I am wrong my VBA code... but not working

We need that the "Holder" series move from 5th to 1st position (Untitled image and VBA code Excel enclosed for your reference)

Kindly correction the VBA code

Thanks for Help....

• ## VBA code for format fill and border line color for Scatter Chart in Excel 2013

Hi i am using the excel 2013

VBA code for format fill and borderline color for Scatter Chart in Excel 2013

I tried the recording macro the “Clustered Bar Chart” and “Scatter Chart”. but I cannot make the recording macro the format fill and border line color

I expect below the chart

1. For series "target" - the Marker Fill color is Red and the same border color, line color is no.

2. For series "actul" - the Marker Fill color is Black and the same border color, line color is no.

Kindly provide the VBA code and Thanks for Advance