Hi - new to Office 2016 (recently used 2007) so this is a bit of a surprise
This code uses data in one book to update in another - I've included ScreenUpdating commands and the two workbooks flicker away during the macro - looks terrible - I'm sure this must have come up somewhere before but I can't find anything simple to substitute in the code?
Please Login or Register to view this content.
There doesn't appear to be any need to be selecting cells or switching between workbooks there, so I would suggest you remove all of that. It will be more efficient and should remove the flicker. Screenupdating doesn't seem to work quite the same in 2016 as it used to.
It should look something like this
Please Login or Register to view this content.
Last edited by xlnitwit; 04-11-2018 at 10:45 AM.
Don
Please remember to mark your thread 'Solved' when appropriate.
HI - thanks for that - only just had chance to get back to it - it seems to scroll though the list but the value (date) in wbLog.Sheets("Sheet2").Range("B3") doesn't appear in foundCell.Offset(0, 17)
I'vet ried stepping through the macro (F8) and I can't see it doing anything?
It's very hard to comment without a workbook but I would assume that the search value is not being found in that case.
Wow - just spotted the problem - the find was pointed to the wrong column - once sorted it was so quick - looks like I'm going to have go back to some similar macros and do some re-writing!
Have fun!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks