Posted to microsoft.public.excel.misc
|
|
What is wrong with this code?
jlclyde wrote:
On Jan 9, 10:53 am, JP wrote:
Try this instead:
copy1.Range("A:A").Cut copy1.Range("H:H")
to do it all in one line, or
copy1.Range("H:H").PasteSpecial(xlPasteAll,xlPas teSpecialOperationNone,fals*e,false)
if you need two lines.
HTH,
JP
On Jan 9, 11:48 am, jlclyde wrote:
copy1.Range("A:A").Cut
copy1.Range("H:H").Paste
Application.CutCopyMode = False
When excel gets to the line of code about pasting it throws an error.
I was wondering if someone coupld enlighten me as to why?
Thanks,
Jay- Hide quoted text -
- Show quoted text -
Thanks. My brain is fried and I coudl not think of this. You are a
life saver, and not the little candies that you can't find anymore.
Jay
Enjoy
http://www.candystand.com/
|