Thank you for your reply.
The problem is that this method DOES remove the rows between the formulas.
What I'm trying to do is copy a the formulas in a whole column so that they
appear in the same rows in the new column. Specifically, I have a balance
sheet for 2007. The column of numbers includes some cells which are formulas
anad some which are number values. I'd like to set up a new column for 2008
to be filled in by the user with the updated figures, and have the formulas
calculate the sums in the appropriate cells.
Using the method you suggested will locate the formulas and I can copy them
to the new column one by one, but I was hoping there was a more efficient way
to copy the column, keeping the formulas but losing the values.
Any other ideas?
Thanks again.