View Single Post
  #11   Report Post  
KeriM KeriM is offline
Member
 
Posts: 70
Default

Quote:
Originally Posted by GS[_2_] View Post
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.