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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste All but Hidden Data?
Sub copyvisiblecells () Range("A1").Select Range(Selection, Selection.End(xlDown)).Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Sheets("Sheet2").Select Range("A1").Select ActiveSheet.Paste end sub This should get you started, substitue your own ranges and sheet names. The key line of code is Selection.SpecialCells(xlCellTypeVisible).Select Best N10 "sefus12" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste All but Hidden Data?
Hi ....,
To eliminate hidden rows when copying, you can use the keyword shortcut Ctrl+A to select all cells (slam the keys again if using Excel 2003) Alt+; (semi-colon) to select visible cells Ctrl+C to copy the selection select new sheet Ctrl+V to paste the selection (without the hidden rows) If you still need a macro, see what happens if you do the above while recording a macro. BTW, If you used a Filter you would only be copying the rows that are unfiltered. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "sefus12" wrote in message ... 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 |
Reply |
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) |