| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste All but Hidden Data?
I've been trying to write a macro to copy and paste data from a column in one spreadsheet over to a column in another spreadsheet. The problem is that the first spreadsheet has several hidden rows of data that I do not need in the second spreadsheet scattered within. Is there a way to copy and paste just the data that is not hidden? Any help would be appreciated. Thanks. -- sefus12 ------------------------------------------------------------------------ sefus12's Profile: http://www.excelforum.com/member.php...o&userid=32755 View this thread: http://www.excelforum.com/showthread...hreadid=525853 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
| paste data over hidden cells that are filtered | Excel Worksheet Functions | |||
| copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
| How to paste data over the hidden rows in a sheet with a filter | Excel Discussion (Misc queries) | |||
| Can I paste data skipping the hidden cells ? | Excel Discussion (Misc queries) | |||
Threaded Mode
