Quote:
Originally Posted by GS[_2_]
Keri,
I tested this in XL2010!
In both case scenarios, Ctrl+F worked as expected!
I placed "Holiday" in A1.
Case1:
When D3 was selected after clicking the button I did Ctrl+F, typed
"Holiday" into the 'Find what' box, then clicked 'Find All'.
Result: A1 selected
Case2:
Using F8 in VBE, at the line 'Stop' I did Alt+F11, Ctrl+F and click
'Find Next'.
Result: A1 selected
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public. vb.general.discussion
|
Garry,
I appreciate you testing it. I'm using Excel 2007, so I wonder if it's a bug with this version. I'm not even sure the proper keyword to google this problem to find out if anyone else has this issue. Hopefully someone with Excel 2007 comes across this thread and tests it out as well. Thank you again.