| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy only where data ends in column
Is it possible to copy a range to where the data ends in a column.
For example the range: Range("D8:J900").Select Selection.Copy If the data ends in D822 then can only data in the range: Range("D8:J822").Select Selection.Copy be copied and at the same time ignore the formulas contained in each and all of the cells within the range? Is this possible? Much appreciate if someone could let me know. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 data import wizard does not support line ends in fields | Excel Discussion (Misc queries) | |||
| setting worksheet so it ends at last data entry in column | New Users to Excel | |||
| Area chart display ENDS before data ? | Charts and Charting in Excel | |||
| filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 | Excel Worksheet Functions | |||
| Data string ends up in first cell instead of Comma sepaerated CSV format | Excel Programming | |||
Threaded Mode
