Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Member
 
Location: London
Posts: 78
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HIDDEN COLUMNS acp20770 Excel Discussion (Misc queries) 1 December 28th 05 06:46 AM
HIDDEN COLUMNS Jolo Excel Discussion (Misc queries) 0 December 27th 05 07:19 PM
Pasting on Filtered Data Sheets without pasting onto hidden cells CCSMCA Excel Discussion (Misc queries) 1 August 28th 05 01:22 PM
excel macros truncating tabs for hidden columns. SharanS Excel Discussion (Misc queries) 0 February 17th 05 05:05 AM
How can I see column headings of hidden columns in Excel before u. Beachcomber Excel Discussion (Misc queries) 10 December 10th 04 01:35 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"