Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2010, 01:56 AM
etodem etodem is offline need to check whether cell contains formula Windows Vista need to check whether cell contains formula Office 2007
Novice
need to check whether cell contains formula
 
Join Date: Apr 2009
Posts: 2
etodem is on a distinguished road
Default need to check whether cell contains formula

Is there any formula (or combination thereof) that says whether a cell contains a formula or not?


specifically i want to distinguish a cell with, for example, =A3*C4, from a cell with just a value, say 13.8
Reply With Quote
  #2  
Old 07-23-2010, 08:34 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline need to check whether cell contains formula Windows XP need to check whether cell contains formula 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
  #3  
Old 10-23-2010, 07:33 PM
MWE MWE is offline need to check whether cell contains formula Windows XP need to check whether cell contains formula Office 2003
Novice
 
Join Date: Oct 2010
Posts: 8
MWE is on a distinguished road
Default

Quote:
Originally Posted by etodem View Post
Is there any formula (or combination thereof) that says whether a cell contains a formula or not?
specifically i want to distinguish a cell with, for example, =A3*C4, from a cell with just a value, say 13.8
Do you want a macro to do this? If so, this is pretty easy.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
need to check whether cell contains formula Formula in a Cell with condition? Learner7 Excel 1 07-19-2010 10:10 AM
need to check whether cell contains formula How can I write the following (whole) formula in a single cell? Learner7 Excel 1 07-19-2010 10:06 AM
need to check whether cell contains formula Protect formula in cell? markg2 Excel 4 05-24-2010 11:50 AM
need to check whether cell contains formula 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 07:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft