Hi

I have a template which uses formulas to drag data from an input sheet
through to a worksheet which manipulates the data. The number of rows of data
on the input sheet is variable. I cannot use activerange because I do not
want to select cells containing formulas which have not resulted in data
being pulled through. What I need is a macro which checks the rows in column
A to see how many have text data pulled through and ignors the rest where
there is a formula but which has not dragged data from the input sheet and
then to select these rows.

This selection would start at A4 (or the user could select the start cell
manually). The area would be limited by the last column which contains text
in any row (and again not formulas).

Thanks for any assistance.