Jan 31st, 2007, 12: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, 12: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 12:50 AM.
The poster formerly known as koolsid
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 - Till Date IMP Links : Acceptable Use Policy, FAQ
Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011
Click Here to Expand Forum to Full Width