Working on code where I have a find element, then from that an offset to grab two numbers and total...
For some reason it randomly is working?Set r = ActiveCell Set cell = Range (“D:D”).Find (r, MatchCase=True)
Working on code where I have a find element, then from that an offset to grab two numbers and total...
For some reason it randomly is working?Set r = ActiveCell Set cell = Range (“D:D”).Find (r, MatchCase=True)
Last edited by jeffreybrown; 06-05-2019 at 05:27 PM. Reason: Please use code tags!
Failing in what way?
There are settings from the user interface that presists when you do a Find from VBA. You should set LookIn and LookAt.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks