Select range containing only values not formulas

[Colnago16]

Hi guys,

I've tried googling this and come damn close to a solution but can't quite work it out.

I've got a table. Some cells contain formulas which will either return a "blank" or a value depending on whats in another cell.

I want to be able to select and copy only the cells that contain values and not cells that are returing blanks.

Hopefully, the attached spreadsheet will make things clear.

Many thanks in advance to anyone who can help a newbie.

[AB33]

Please Login or Register  to view this content.

[Colnago16]

Hi AB33,

Thanks for the quick reply.

Thats not quite what I'm after.

To clarify. I want to end up with the range A1:C5 selected where as your code only selects data in column C. At the moment my original code is selecting A1:C10 because it's also selecting cells with formulas in but I don't want it to do this.

[AB33]

There is not direct function, but can go around way.

Please Login or Register  to view this content.

[Colnago16]

Perfect!

Thank you

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Colnago16]

Thanks John, that works great too!

[JOHN H. DAVIS]

You're welcome. Glad to help out.