Thanks Guys: I would sware on a bible that I tried your(Don's) line of code and it didn't work for me. Something else must not have been aligned exactly right and it failed. This time it worked. The problem may have been the find, since Dave points out a big problem with the find holding on to the last application's options. Again, a big thank you, to both Don and Dave, for the assist
This will fail if "sam501" isn't found. I think that this is better: Dim FoundCell as range with activesheet set foundcell = .range(.cells(5,7),.cells(5,251)).find("sam501") end with if foundcell is nothing then msgbox "not found" else foundcell.select 'not usually necessary msgbox foundcell.column end if ===== Ps. It's usually much better to specify all the parms in that
On Mon, 9 Jun 2008 17:09:30 -0700 (PDT), SloCalSpode <jjwallace@earthlink.net> wrote: Hi Fred: Fear not. I have shot the .308 in a Thompson Encore and it was a pussy cat. Nice fire ball and a pretty loud bark, but, a pussy cat just the same. My .223 Contender is a dream to shoot. Less re-coil than a .38 with target wad cutters. It has the preverbial "Glass trigger" Zero take
Hi Fred: Fear not. I have shot the .308 in a Thompson Encore and it was a pussy cat. Nice fire ball and a pretty loud bark, but, a pussy cat just the same. My .223 Contender is a dream to shoot. Less re-coil than a .38 with target wad cutters. It has the preverbial "Glass trigger" Zero take-up and almost no over travel. On a windless day with a sand bag. Put the crosshairs on anything
Chom Noamsky pretended : "Sanity" <newsgroupjunkies@getalife.ca> wrote in message news:ZTLtj.21616$FO1.17711@edtnps82... Wanna get a reaction from a women? Use the word "cunt" in any context or sentence and they will literally string you up on sight. This got me to thinking, when I hear someone use that term in the presence of women, not only is there an instinctual nervous
