Restrict the row count to the values only in the sheet

[arkk]

Hi All,

In my data sheet I have some data. The number of rows in which data is filled is 80. When I do Ctrl+End the end cell it takes me is around 65536. This is the row count shown in the vbscript. How can I make selection restricted so that when I do ctrl+End it goes to the end of 80th cell and not beyond.

I tried selecting the cells from 81 to ctrl+shift+end and delete but still no luck

Many Thanks

 

[NARAYANK991]

Hi ,

After you do the row , column deletion , you should save the workbook and re-open it. Excel saves the UsedRange with the workbook , and when you re-open , you should see that CTRL END does not go beyond the 80th row.

Narayan

 

[arkk]

Thanks Narayan. It works .