I have had a very simple prerecorded Macro for years that simply takes what was copied onto the clipboard and pastes into a excel file. Suddenly I am getting the above error on both my laptop and desktop computers.
Any help would be greatly appreciated.
(I am using Excel 2007)
-------------------
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/2/2007 by GReuben
'
'
Range("A1").Select
ActiveSheet.Paste
End Sub
------------------
If you want to paste, your first have to copy:then you have to specify where you want to paste:
Please Login or Register to view this content.This will copy from A1 to B1.Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you for your prompt reply. I should have been more specific. I am actually copying from another source. I was then able to go into EXCEL and PASTE. I was always very pleased that everything lined up really well. CREW.gifcrew excel.gif
I don't know what your source is but how it pastes depends on how it is formatted at the source. It may paste everything into one cell or it may paste everything really nicely in rows and columns.
The paste has been able to maintains the rows and columns.
I tried copying some data from an outside source and then used your macro to paste it into a worksheet and it worked perfectly for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks