Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to identify contents of a cell
Does anyone know a way to identify which cells contain values vs formulas?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to identify contents of a cell
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- "SLS" wrote in message ... Does anyone know a way to identify which cells contain values vs formulas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to identify contents of a cell
Hi
msgbox range("A1").hasformula -- Regards Frank Kabel Frankfurt, Germany "SLS" schrieb im Newsbeitrag ... Does anyone know a way to identify which cells contain values vs formulas? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to identify contents of a cell
Hi SLS,
'\\ Use the SpecialCells method to identify all formula cells in a given range: On Error Resume Next Set rng = Range("A1:D100").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 --- Regards, Norman "SLS" wrote in message ... Does anyone know a way to identify which cells contain values vs formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Contents to identify source Filename | Excel Discussion (Misc queries) | |||
In Excel, how do I identify the contents of a cell as numerical o. | Excel Discussion (Misc queries) | |||
Run code based on cell contents | Excel Programming | |||
How to validate in code the contents of a cell? | Excel Programming | |||
run code after cell contents change | Excel Programming |