Hi,
I need to filter cells with formulas and not to select them , is that possible by a simple or advanced filter ?
Thank you .
Hi,
I need to filter cells with formulas and not to select them , is that possible by a simple or advanced filter ?
Thank you .
Maybe....
But I think you'll have to expand on what you really want...
gaftalik wrote:
>
> Hi,
> I need to filter cells with formulas and not to select them , is that
> possible by a simple or advanced filter ?
> Thank you .
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
> View this thread: http://www.excelforum.com/showthread...hreadid=488232
--
Dave Peterson
In a range of cells which contains constant values and formulas , i need to add a filter or a macro to filter all cells that contain only formulas in a way to hide the rows in which there is a constant value cell ! is that possible ?
Thank you much .
You could use a UserDefined Function that returns true/false depending on if
there's a formula in that cell:
Option Explicit
Function HasFormula(rng as range) as boolean
set rng = rng.cells(1) 'only one cell
HasFormula=rng.hasformula
end function
Then you could add a column of helper cells that contain formulas:
=hasformula(a1)
(and drag down)
and filter on that.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
gaftalik wrote:
>
> In a range of cells which contains constant values and formulas , i need
> to add a filter or a macro to filter all cells that contain only
> formulas in a way to hide the rows in which there is a constant value
> cell ! is that possible ?
>
> Thank you much .
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
> View this thread: http://www.excelforum.com/showthread...hreadid=488232
--
Dave Peterson
Thank you much . It worked well .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks