Hi

Could someone please advise on a simple way of selecting a variable area
from a workbook, for example for copying, as it keeps croping up in various
tasks?

In the application I am looking at now the number of columns is fixed at 21
('U') but the number of rows will change. Ideally I'll select the first cell
ie A1 and then run a macro which will count the number of rows which contain
text (other than spaces)to work out the range required by combining with the
number of columns and then select the entire range ready for copying and
pasting. Of course a more flexible version which also automatically worked
out the number of columns would be of interest.

Thanks for any help

G