Find out whether a cell has been typed or calculated

		Microsoft Office Forums > Microsoft Excel > Excel
Find out whether a cell has been typed or calculated

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-01-2013, 11:41 AM

Pecoflyer

Windows 7 64bit Find out whether a cell has been typed or calculated

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Perhaps use following UDF

Code:

Function IsFormula(cell_ref As Range)
IsFormula = cell_ref.HasFormula
End Function

Place it in a general module.
=IsFormula(A1) will return True or False

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

conditional formatting, formulas, vlookup

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
the character "v" when typed acts like ctrl-v.	jim redfield	Word	1	09-22-2012 05:19 AM
Can I set AutoCorrect to work with inserted text (not typed)?	kyjac85	Word VBA	3	09-14-2012 08:19 PM
Inserting a date calculated from a table cell	theMikeD	Word	2	09-11-2012 05:46 PM
Text typed on slide x ports to slide y automatically?	Thinker	PowerPoint	5	07-26-2012 11:59 PM
Calculated dates.	Ziggy-R	Word	10	09-28-2010 01:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:35 PM.