Avatar of Randy Downs
Randy Downs
Flag for United States of America

asked on 

Excel VBA Select Column Very Slow

Using old macros created long ago and they used to work OK but Excel 2013/2016 take a couple of minutes to select a column. There are less than 500 rows in the spreadsheet.

Any ideas how to speed this up?

' Locate last record in database 2 minutes 39 seconds

   Selection.Find(what:="", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
        xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
   sze = Selection.Row

Open in new window

Microsoft ExcelVBAProgrammingSpreadsheets

Avatar of undefined
Last Comment
Randy Downs

8/22/2022 - Mon