I have a range of cells with formulas (A2:A25)
In that range, only some cells come back with a value for our example let's say that ONLY cells A2 through A5 returned a value.
& cells A6 though A25 does not return a value, the cells only contains formulas. To the eye, the cells appear blank but they are not, they contain formulas.
I only want to select the range of cells that have a value NOT formula.
If I Do a CTRL+SHFT + (Down Arrow),it selects all cells...it doesn't stop at A5.
I also tried GO TO.. SPECAL... select "Blank" option, it does not work
I want the selection to stop at A5.
Can you help
In that range, only some cells come back with a value for our example let's say that ONLY cells A2 through A5 returned a value.
& cells A6 though A25 does not return a value, the cells only contains formulas. To the eye, the cells appear blank but they are not, they contain formulas.
I only want to select the range of cells that have a value NOT formula.
If I Do a CTRL+SHFT + (Down Arrow),it selects all cells...it doesn't stop at A5.
I also tried GO TO.. SPECAL... select "Blank" option, it does not work
I want the selection to stop at A5.
Can you help