need to check whether cell contains formula

		Microsoft Office Forums > Microsoft Excel > Excel
need to check whether cell contains formula

07-23-2010, 08:34 AM

ConneXionLost ConneXionLost is offline

Windows XP need to check whether cell contains formula

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

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

Code:

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

Cheers,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula in a Cell with condition?	Learner7	Excel	1	07-19-2010 10:10 AM
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
Protect formula in cell?	markg2	Excel	4	05-24-2010 11:50 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 AM.