Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting A Range
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help with selecting a range | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Help please in selecting range dependent on another range | Excel Programming | |||
Selecting a Range inside a range | Excel Programming | |||
Selecting the end of a range | Excel Programming |