VBA Code to identify contents of a cell

[Guest]

Does anyone know a way to identify which cells contain values vs formulas?

 

[RobFMS]

This will be helpful:

Tip #2: Excel Automation: More than just a formula
http://www.fmsinc.com/free/tips.html#ExcelautomationVBA

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Frank Kabel]

Hi
msgbox range("A1").hasformula

--
Regards
Frank Kabel
Frankfurt, Germany

Does anyone know a way to identify which cells contain values vs

formulas?

 

[Norman Jones]

Hi SLS,

'\\ Use the SpecialCells method to identify all formula cells in a given
range:
On Error Resume Next
Set rng = Range("A1100").SpecialCells(xlFormulas)
On Error GoTo 0

'\\ Check if an individual cell contains a formula:
If Range("A1").HasFormula = True Then
'A1 contains a formula
End If

'\\ Determine if all cells in a range are formulae:
If rng.HasFormula = True Then
'all the cells in rng1 are formulae
End If