ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copied empty cells, give sorting problem in Data sheet (https://www.excelbanter.com/excel-programming/310111-copied-empty-cells-give-sorting-problem-data-sheet.html)

Ruud[_2_]

Copied empty cells, give sorting problem in Data sheet
 
When I copy a range of cells to my Data Sheet, the empty-cells
from that block gives a sorting problem. (The Old empty cells
are below the data, the new empty cells are above the data)

When I erase these empty cells in my Data sheet, everything
works fine again. I tried all items from "Paste Special"

Is there a solution?
Ruud


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com