Jan 31st, 2007, 01:30 AM
Know very little about vb programming so was hoping for some help.
The below code work alright but only for rows 10-14 - it appears the pastesepcial doesnt work for the reminding 15-26 rows. Can anyone explain to me how Selection.PasteSpecial works?
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
Jan 31st, 2007, 01:45 AM
Welcome to the Forums
Does this help?
Application.CutCopyMode = False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
'and so on...
Tip: Whenever in doubt create a macro on what you want to do and then amend it as per your requirements
Here is a tutorial by RobDog888 on 'Recording Macros'...
Hope this helps...
Last edited by Siddharth Rout; Jan 31st, 2007 at 01:50 AM.
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
Microsoft MVP: 2011 - 2015 IMP Links : Acceptable Use Policy, FAQ
ACER R7 (Win 8.1+Office 2013+VS2013) || Sony VPCCB-45FN with a Win10+Office 2010. || Mac Book Pro (10.6.8) with Office 2011
Click Here to Expand Forum to Full Width
Survey posted by VBForums.