Re: Help - Apply Formatting To Current Row
- From: JLatham <HelpFrom @ Jlathamsite.com.(removethis)>
- Date: Sun, 5 Aug 2007 10:24:03 -0700
I've heard of others having troubles lately in seeing posts in these forums -
particularly when attending through Google groups. The Google folks are
supposed to be working on their end of it. I don't know if that's got
anything to do with the problem you're experiencing or not. But it does
answer the one big question that so many have asked for so long: "Am I alone
in all of this?" And the answer is a resounding "NO! You are not alone." <g>
Things are always dynamic around here: one day viewing with web browser
works fine, next day it doesn't and a newsreader is needed, then the whole
thing flip flops a week later, then during the 4th quarter of the moon after
the 2nd full moon following the vernal equinox (barring sufficient
sacrificial offerings to appease the newsreader gods) NOTHING works! <G>
Heiku, glad that we could assist you. Enjoy.
"Dallman Ross" wrote:
In <481243E3-1782-47C2-80E2-3959262ABAA2@xxxxxxxxxxxxx>, JLatham.
<HelpFrom @ jlathamsite.com.(removethis)> spake thusly:
Dallman,
I know that the OP said "any selected row", and indeed, if he
has entire row selected when he runs your macro, it works as he
desires. As such, it fits the bill exactly!
Glad Heiko's problem is solved.
I'm also glad you followed up like this, because I didn't see any
other followup to him other than mine. I don't see your code! My
newsserver has holes in these articles.
I now suspect others have been answering me in some of the threads I've
started or contributed to, but I cannot see many of those answers.
I asked my news administrator about this the other day, and got this
answer about one followup I only saw quoted in another poster's answer:
> > I'm sending the below article because it is a response to
> > my posting in microsoft.public.excel.misc, which we carry,
> > and because it quotes another poster who responded to me but
> > whose post did not show up on our servers.
>
> The post this was following up to (with the Message-ID of
> <E338550D-D7C1-4A9A-855A-EEF722D3B4AD@xxxxxxxxxxxxx>) was
> rejected by Cleanfeed. The particular test that it triggered
> is one that takes a hash of article headers (in this case,
> Posting-Host and number of lines) and, if too many come in
> with the same hash in the same period of time, rejects them as
> likely spam.
The admin goes on to say this may well be happening to other articles
here. I'm sure it is! :-(
To explain why I did it the way I did: I kind of presumed that
often people don't say what they mean here in the forums, and
that they might have just a single cell selected in a row - in
which case, the code I tossed together would make up for a little
laxness on the part of the end user.
On the other hand, the line is only at the bottom of the range. So
if he selects just the bottom cell in the row, my version will also
work. But he seems, in his followup, to be enamored of yours, so --
congrats. :-) Maybe I'll find your code on the web or something.
I suspect I know what it says, more or less, based on your comments,
however.
Dallman
- References:
- Help - Apply Formatting To Current Row
- From: Heiko@xxxxxxxxx
- Re: Help - Apply Formatting To Current Row
- From: Dallman Ross
- Re: Help - Apply Formatting To Current Row
- From: JLatham
- Re: Help - Apply Formatting To Current Row
- From: Dallman Ross
- Help - Apply Formatting To Current Row
- Prev by Date: Re: Sub to extract uniques from 200k data in xl03
- Next by Date: Combo boxes
- Previous by thread: Re: Help - Apply Formatting To Current Row
- Next by thread: select case question
- Index(es):
Relevant Pages
|