Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You're quite right!
It works IF the source selection is a single cell, and not if the source selection is multiple cell. You could try the following though, assigning them to a couple of shortcut keys: '###CODE BEGINS HERE Public xSel As Range Sub CopyCustom() Set xSel = Selection.Cells End Sub Sub PasteCustom() nCell = 0 For Each xCell In Selection.Cells If Not (xCell.EntireRow.Hidden Or xCell.EntireColumn.Hidden) Then nCell = nCell + 1 xCell.Value = xSel.Cells(nCell).Value End If If nCell = xSel.Cells.Count Then nCell = 0 End If Next xCell End Sub '###CODE ENDS HERE Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HIDDEN COLUMNS | Excel Discussion (Misc queries) | |||
HIDDEN COLUMNS | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) |