Thread: Getting wrong last cell when using usedrange in macro in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JeffL JeffL is offline
external usenet poster
  
Posts: 8
Default Getting wrong last cell when using usedrange in macro in Excel

I've been told that using ActiveSheet.UsedRange will reset the special cell
LastCell after deleting from a sheet, but Excel says the last cell is at Y102
when it should be Y10. There is nothing on row 102 at all. What's happening?
Reply With QuoteReply With Quote