Microsoft Office Forums - View Single Post - [Solved] need to check whether cell contains formula

Thread: [Solved] need to check whether cell contains formula

View Single Post

Old

07-23-2010, 08:34 AM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

Here's a UDF that will do what you ask:

Code:

Function IsFormula(cell)
  IsFormula = cell.HasFormula
End Function

Cheers,

Reply With Quote