Member Avatar for rahul.katiyar.7731

I want the vba coding of the formula SUMIFS in MS-Excel 2007, so I can copy the code and paste it in the Module of MS-Excel 2003 to use the formula in this version.

[url=http://damdamalakeresort.com/]Damdama Lake[/url]

  • 2 Contributors
  • 2 Replies
  • 260 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by rahul.katiyar.7731
Member Avatar for imBaCodes

What kind of Formula?
A macro? or Like This.

=SUMIFS(A1:A20, B1:B20, ">0", C1:C20, "<10")
Member Avatar for rahul.katiyar.7731

theres no formula that can tell the difference between a formula and a harcoded cell.
so i recorded a quick macro for column B

Sub formulaB()
'
' formulaB Macro
'

'
Range("B1:B1000").Select
Selection.SpecialCells( xlCellTypeFormulas, 23).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub

<a href="http://scattoursindia.com/damdama.html">damdama lake</a>

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.