| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select cells with values only (not empty ones)?
My problem is that I am using a macro to copy data from one workbook and to
paste into the next, however along with the data I need come about 30,000 blank rows, making the file large. I could use Go Toblanks and Delete the 30,000 once pasted but that takes alot of time to sit through. Idealy I could use Go To(Insert something that selects only non-empty cells) And then copy/paste that into the new workbook. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When creating a formula how do you select only visible cells | Excel Discussion (Misc queries) | |||
| Save trailing empty cells in a tab delimited text file | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
