ARRRGGG!! Another 1/2 hour is wasted. How many times have us VBA’ers did a paste and then realized the paste split the columns for us – using commas – but then the data gets all wonky on columns that are  off the page so-to-speak. So – how do we reset the paste parameters to the proper values before we begin – well you to fake a Text-To-Columns on a new sheet or fake cell – then do a paste. It is really annoying. A quick google showed others are quite annoyed to. Why can’t we check what the parameters are currently? When I find out – I will post them here. In the mean time, follow this guys advice.