Can not delete rows (tried everything?)

[Dart180]

Hello!


One of my sheets contain over 700,000 rows that can not be deleted. This makes it impossible to navigate the 2500 rows with text.


I have tried:


- CRTL+Shift + Down Arrow/Left Arrow --> Right Click ---> Delete.
- CRTL+Shift + Down Arrow/Left Arrow --> Right Click ---> Clear Contents.
- Editing - Clear - Clear All
- Above methods + save the workbook and restart Excel.
- Delete all macros.
- Copy the 2500 rows with text to a new workbook (!!!)


Nothing has worked.


Does anyone have a solution?

 

[Teeroy]

Try the following to test @mole999's theory (which is a good one) while having the subject sheet active.

Sub FindComments()
Dim cmnt As Comment
For Each cmnt In ActiveSheet.Comments
    Debug.Print cmnt.Parent.Address
Next
End Sub

This will list the location of all comments on the ActiveSheet in the Immediate window.

 

[Dart180]

I've had cell comments cause layout problems, any of those in the sheet

Worked!

Thanks guys for you'r support!