LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default paste special does not work

why the paste special brings an error message : runtime error 1004:
Pastespecial method of range class failed

Private Sub CommandButton3_Click()
Dim recordnumber As String
Dim a, b, c As String
Dim recordno As Integer
recordno = countrecords + 1
a = "A" & recordno
b = "HO" & recordno
c = a & ":" & b
For Each cell In Worksheets("Intro Page").Range("K63:K103")
If cell.Value = "" Then
cell.Value = Worksheets("Temporary Record").Range("B1")
Exit For
End If
Next cell

Worksheets("Temporary Record").Activate
Worksheets("Temporary Record").Range("B1:B223").Select
Selection.Cut
Worksheets("Saved Records").Activate
Worksheets("Saved Records").Range(c).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=False, Transpose:=True

End Sub
 
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
why don't my functions in paste special work? Gene Excel Worksheet Functions 2 September 10th 06 05:33 PM
Paste special into a filtered work sheet SmithDelgado Excel Worksheet Functions 0 June 20th 06 06:20 PM
How does the PASTE.SPECIAL function work? Curt Excel Discussion (Misc queries) 6 July 28th 05 07:58 PM
Paste Special won't work in VBA Ed[_9_] Excel Programming 3 August 18th 03 03:49 PM


All times are GMT +1. The time now is 02:46 AM.

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"