Identifying Cells with formulas

[VETcalc]

I am aware of the VBA approach to identifying Cells with formulas. My question,
is there anyway to use a Excel Function with logic to identifying a cell that contains
a formula?

In advance, thank you for your help!

Bob

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Krishnakumar]

Hi,

See this

HTH

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>

[Gary's Student]

Please ignore this answer if some one can help you without resorting to UDFs.
Otherwise this tiny UDF:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

will tell you TRUE/FALSE if cell has a formula.
--
Gary's Student


"VETcalc" wrote:

>
> I am aware of the VBA approach to identifying Cells with formulas. My
> question,
> is there anyway to use a Excel Function with logic to identifying a
> cell that contains
> a formula?
>
> In advance, thank you for your help!
>
> Bob
>
>
> --
> VETcalc
> ------------------------------------------------------------------------
> VETcalc's Profile: http://www.excelforum.com/member.php...o&userid=13078
> View this thread: http://www.excelforum.com/showthread...hreadid=395346
>
>