This part of a code threw an odd anomoly when updating a record. It was because this apparently searches the whole used range
How can I restrict the search to used rows in column A only
Any help appreciated
Please Login or Register to view this content.
Last edited by nigelog; 10-06-2017 at 12:35 PM.
How about this ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Perfect Many thanks
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks