Macro error when trying to paste ???
Closed
JoshMarotte
-
Jun 25, 2012 at 11:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 25, 2012 at 08:00 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 25, 2012 at 08:00 PM
Related:
- Macro error when trying to paste ???
- Network error occurred - Guide
- Cmos checksum error - Guide
- Error code: 230000 - Video Forum
- Bios rom checksum error - Guide
- Discord invisible name copy and paste ✓ - Internet & Social Networks Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 25, 2012 at 08:00 PM
Jun 25, 2012 at 08:00 PM
I have not tried it but try instead of
theCell.Parent.Activate
theCell.EntireRow.Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
theCell.Parent.Activate
theCell.Range(theCell.Row, 1).PasteSpecial
theCell.Parent.Activate
theCell.EntireRow.Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
theCell.Parent.Activate
theCell.Range(theCell.Row, 1).PasteSpecial