I think I have finally have copy and paste working in all scenarios now correctly, but i encountered something today that I cant figure out whats happening. I have attached a sample in which u can reproduce my problem. Run the sample. Column B has data in it. Now this is the confusing part. If u select the one cell in row1 column b and click edit on my menu and then click copy. Then select the whole coulmn B by clicking its header in row0 column B. Then again click edit in my menu then copy. Now scroll over to the right so that u have columns F,G,H,I,J on the screen. Now select the column header of J to select the whole column and then go to the edit menu again and click paste. It pastes fine but notice how it scrolls ur grid back so that the column u copied from is in focus? Why is that. If i do almost the same thing as i walked u through above but skip the single cell selection and then edit and copy it doesnt do this. So if u close the app and open it up and just select column B then click edit and copy..then scroll to where u have f,g,h, i,j in view and then select column J and click edit paste u will notice it doesnt scroll the column u copied from back in view? The reason if u wonder why in the copy and paste where i decide if its a single cell versus a range is related to another question i asked u where u told me that single cell vs range copy and paste act differently. Any ideas??
copyandpaste2_3386.zip