Gah Brain Fart

[gwkenny]

Having a brain fart.

Need to test if a cell is a formula or directly entered value.

Thanks,

g-

 

[Andrew Poulsom]

In VBA use the HasFormula Property of the Range object.

 

[gwkenny]

Thanks.

Wanted to do it straight on a spreadsheet though with existing functions.

Ideally this is to be used as a logical test for some conditional formatting in another part of the sheet. It's a cosmetic detail. Not worth me programming the test into a custom function (although the time I spent thinking about this simple thing I coulda done that a few times over, lol).

Thanks for responding though!

g-

 

[Aladin Akyurek]

On 2002-10-31 03:00, gwkenny wrote:
Thanks.

Wanted to do it straight on a spreadsheet though with existing functions.

Ideally this is to be used as a logical test for some conditional formatting in another part of the sheet. It's a cosmetic detail. Not worth me programming the test into a custom function (although the time I spent thinking about this simple thing I coulda done that a few times over, lol).

Thanks for responding though!

g-

There is no native worksheet function that does what you want.

 

[gwkenny]

Wahhhhhhhh, lol.

Well, I'm a geek. Guess I'll open up my VB Editor

Thanks!

g-
(still jealous about your solution with regards to matrix math where you multiply two arrays but one of the arrays had to be in reverse order!!!)

 

[Ivan F Moala]

On 2002-10-31 03:03, Aladin Akyurek wrote:

On 2002-10-31 03:00, gwkenny wrote:
Thanks.

Wanted to do it straight on a spreadsheet though with existing functions.

Ideally this is to be used as a logical test for some conditional formatting in another part of the sheet. It's a cosmetic detail. Not worth me programming the test into a custom function (although the time I spent thinking about this simple thing I coulda done that a few times over, lol).

Thanks for responding though!

g-

There is no native worksheet function that does what you want.

Actually there is a way to do this Using Xl4

Just Define a name as
IsFormula

In the refers to type in
=GET.CELL(48,Sheet1!$A$1)
Where $A$1 is the cell range to reference

Then just Type in a cell
=IsFormula

Result will be True of False

 

[gwkenny]

Just incredible

Thanks!

g-

 

[PaddyD]

Re the get.cell, see:

http://216.92.17.166/board/viewtopic.php?topic=21312&forum=2

for more info. Note especialy the warning re it's use in the link aladin posted.

paddy