LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Reuel Other Help

Thanks to Reuel for your reply to an old post of mine. It had mostly
cleared up on a newer computer but has now raised its head again... I
can only imagine because of the scheer number of lines in the
spreadsheet (processing 360 lines now)... the piece of code that
sometimes goes wrong is...

Sheets("MonthlyReceipts").Copy After:=Sheets(2) 'because I don't want
to redo the changes I am making with the macro
ActiveSheet.Unprotect
'because it is protected

ActiveSheet.Columns("E:E").Delete 'just because

'Deletes all 'blank'
ActiveSheet.Range("A9:E9").AutoFilter Field:=5, Criteria1:="="
'this does filter column E to only show blanks but then causes the
error

ActiveSheet.AutoFilter.Range.Select
'this would delete the blank rows and the first row of the
Filter
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete

Most of the time it is fine but now it is Filtering over 300 rows it
errors everytime.

Any help...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"