LinkBack URL
About LinkBacks
I"m copying 50 cells in an Excel sheet and when I paste them into a new sheet I get 65,000 cells pasted. Can anyone help me!:
I"m copying 50 cells in an Excel sheet and when I paste them into a new sheet I get 65,000 cells pasted. Can anyone help me!:
How are you copying the cells? Selecting and copying the range, right? Or are you pressing Ctrl+A?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I am highlighting, right clicking and selecting copy. Then i open the new sheet and right click and paste and i get 65,000
I am selecting these cells out of a sheet that has 1800 cells.
Each sheet by default will have 65536 rows if you are using excel 2003. So even if you are picking cells and copy pasting, they will form part of the overall 65k rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks