Driver to drive?

[Archimedes' Lever]

On Sun, 5 Apr 2009 09:04:51 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

Can you post the code?

Cheers


Sure, here you go:

Sub selprint()
Dim i As Integer
Dim currentsheet As Worksheet

For i = 1 To ActiveWorkbook.Worksheets.Count
Set currentsheet = ActiveWorkbook.Worksheets(i)
Worksheets(i).Activate
'Skip empty sheets and hidden sheets
If Application.CountA(currentsheet.Cells) <> 0 And currentsheet.Visible
Then
'change the hard-coded cell here if not F52
If (Not IsNull(Range("F52"))) And (Range("F52").Value <> 0) Then
'un-comment the next line when debugging completed
' ActiveSheet.PrintOut
'add comment at start of next line when debugging completed
ActiveSheet.PrintPreview
End If
End If
Next i
End Sub


Jim

I was able to get it to work, and will post my test sheet up in a.b.s.e
momentarily.

I had the same issue you did, and fount the cause to be cell formatting
issues. The cell must be formatted as a number, and the cell, if filled
from another location must have been filled as a number.

 

[Fred Abse]

On Sun, 05 Apr 2009 07:16:25 -0700, bill.sloman wrote:

Probably

"Israelis shoot and kill an armed woman"

but it's longer than

"Israelis shoot dead armed woman"

and headlines have to be short.

So why not:

"Israelis shoot armed woman dead"

Exactly same character count.

--
"Electricity is of two kinds, positive and negative. The difference
is, I presume, that one comes a little more expensive, but is more
durable; the other is a cheaper thing, but the moths get into it."
(Stephen Leacock)

 

[Joerg]

Archimedes' Lever wrote:

On Sat, 04 Apr 2009 17:24:29 -0700, Joerg
notthisjoergsch@removethispacbell.net> wrote:

Any tricks?


When you prep the shield area, remove a layer or two at the fold point.
Then when you fold it back it will have less overall volume to shove
inside the fitting's crimp area.

I did that, peeled off all the foil, leaving just the braid. Won't go in :-(

--
Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.
Use another domain or send PM.

 

[Joerg]

Jasen Betts wrote:

On 2009-04-05, Joerg <notthisjoergsch@removethispacbell.net> wrote:
Hello,

Like usual the TV distribution amps in our house have those darn
F-connectors. I hate them. Long story short, I ran out of the
gold-plated "good stuff", can't get it in the local stores anymore,
could only buy a nickel plated F-connector. Dimensions checked out to be
the same as this example:

http://www.amazon.com/dp/B0002ZPFBW/ref=asc_df_B0002ZPFBW754974?smid=A385A0XNQBW8HY&tag=shopzilla_rev_1108-20&linkCode=asn

190mils center ID, slides over center nicely. 330mils ID for the
ferrule, and for the life of me I can't get that over the quad shield
with the shield strands brushed back. This was never a problem with the
good stuff but since I used that all up I have no idea what their
ferrule ID was.

Any tricks?

you don't used those with brushed back braids on quad shield.

cut the braids and sheath square and push them on, crimp with
a 0.360" hex crimp tool

I tried that also, on a scrap piece. Can't get it in. Also, this carries
the risk that it just pushes the shield back inside and doesn't make a
good contact.

--
Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.
Use another domain or send PM.

 

[Joerg]

Jan Panteltje wrote:

On a sunny day (Sat, 04 Apr 2009 17:24:29 -0700) it happened Joerg
notthisjoergsch@removethispacbell.net> wrote in
9TSBl.15602$W06.13688@flpi148.ffdc.sbc.com>:

Hello,

Like usual the TV distribution amps in our house have those darn
F-connectors. I hate them. Long story short, I ran out of the
gold-plated "good stuff", can't get it in the local stores anymore,
could only buy a nickel plated F-connector. Dimensions checked out to be
the same as this example:

http://www.amazon.com/dp/B0002ZPFBW/ref=asc_df_B0002ZPFBW754974?smid=A385A0XNQBW8HY&tag=shopzilla_rev_1108-20&linkCode=asn

190mils center ID, slides over center nicely. 330mils ID for the
ferrule, and for the life of me I can't get that over the quad shield
with the shield strands brushed back. This was never a problem with the
good stuff but since I used that all up I have no idea what their
ferrule ID was.

Any tricks?

I dunno, but you keep surpising me....
TV distribution amps???? 1960????
LOL
Just get the digital mpeg on wireless or ethernet.

Not out here. We get the TV analog and digital over an antenna, starting
this summer only DTV. Goes through the same amps, no problem.

--
Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.
Use another domain or send PM.

 

[Joerg]

Martin Riddle wrote:

"Joerg" <notthisjoergsch@removethispacbell.net> wrote in message
news:9TSBl.15602$W06.13688@flpi148.ffdc.sbc.com...
Hello,

Like usual the TV distribution amps in our house have those darn
F-connectors. I hate them. Long story short, I ran out of the
gold-plated "good stuff", can't get it in the local stores anymore,
could only buy a nickel plated F-connector. Dimensions checked out to
be the same as this example:

http://www.amazon.com/dp/B0002ZPFBW/ref=asc_df_B0002ZPFBW754974?smid=A385A0XNQBW8HY&tag=shopzilla_rev_1108-20&linkCode=asn

190mils center ID, slides over center nicely. 330mils ID for the
ferrule, and for the life of me I can't get that over the quad shield
with the shield strands brushed back. This was never a problem with
the good stuff but since I used that all up I have no idea what their
ferrule ID was.

Any tricks?

--
Regards, Joerg

You have the wrong F connector.
Quad shield F's are much bigger monsters
http://www.amazon.com/Monster-Cable-crimp-connector-quad-shield/dp/B0002378AA

Aha! Thanks. This link doesn't have any dimensions but yeah, probably
they sold me the wrong stuff.

--
Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.
Use another domain or send PM.

 

[Joerg]

Jim Thompson wrote:

On Sat, 04 Apr 2009 17:24:29 -0700, Joerg
notthisjoergsch@removethispacbell.net> wrote:

Hello,

Like usual the TV distribution amps in our house have those darn
F-connectors. I hate them. Long story short, I ran out of the
gold-plated "good stuff", can't get it in the local stores anymore,
could only buy a nickel plated F-connector. Dimensions checked out to be
the same as this example:

http://www.amazon.com/dp/B0002ZPFBW/ref=asc_df_B0002ZPFBW754974?smid=A385A0XNQBW8HY&tag=shopzilla_rev_1108-20&linkCode=asn

190mils center ID, slides over center nicely. 330mils ID for the
ferrule, and for the life of me I can't get that over the quad shield
with the shield strands brushed back. This was never a problem with the
good stuff but since I used that all up I have no idea what their
ferrule ID was.

Any tricks?

Forgot... There ARE dimension differences on Type-F for different coax
such as RG-6 and RG-59. Read carefully!

I know, this one was for RG6. But probably not for the quad-shield kind.
The RG59 version is smaller, I've got those here as well.

Thanks for the hint regarding Lowes, we've got a store in the area, 15
miles or so.

--
Regards, Joerg

http://www.analogconsultants.com/

"gmail" domain blocked because of excessive spam.
Use another domain or send PM.

 

[Eeyore]

Archimedes' Lever wrote:

"ian field" <gangprobing.alien@ntlworld.com> wrote:
"Jim Thompson" <To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote

Command of the Queen's English?

BBC headline...

"Israelis shoot dead armed woman"


I've heard of a "dead leg" but not a dead arm.

The woman was dead, not her arm.

Dead, armed woman.

Requires an apostrophe you see.

Graham

 

[Eeyore]

Archimedes' Lever wrote:

krw <krw@att.bizzzzzzzzzzz> wrote:

I'm not AlwaysWrong, DimBulb.

Yes... You... Are... ALWAYS WRONG. Just like you were right there
by calling me by a name other than my own, you fucking retard.

Just how many aliases has the twit used ? How about a competition to list them all
?

Graham

 

[Jim Thompson]

On Sun, 05 Apr 2009 13:59:20 -0700, Joerg
<notthisjoergsch@removethispacbell.net> wrote:

Jim Thompson wrote:
On Sat, 04 Apr 2009 17:24:29 -0700, Joerg
notthisjoergsch@removethispacbell.net> wrote:

Hello,

Like usual the TV distribution amps in our house have those darn
F-connectors. I hate them. Long story short, I ran out of the
gold-plated "good stuff", can't get it in the local stores anymore,
could only buy a nickel plated F-connector. Dimensions checked out to be
the same as this example:

http://www.amazon.com/dp/B0002ZPFBW/ref=asc_df_B0002ZPFBW754974?smid=A385A0XNQBW8HY&tag=shopzilla_rev_1108-20&linkCode=asn

190mils center ID, slides over center nicely. 330mils ID for the
ferrule, and for the life of me I can't get that over the quad shield
with the shield strands brushed back. This was never a problem with the
good stuff but since I used that all up I have no idea what their
ferrule ID was.

Any tricks?

Forgot... There ARE dimension differences on Type-F for different coax
such as RG-6 and RG-59. Read carefully!


I know, this one was for RG6. But probably not for the quad-shield kind.
The RG59 version is smaller, I've got those here as well.

Thanks for the hint regarding Lowes, we've got a store in the area, 15
miles or so.

Those Ideal (brand) connectors are so easy to work with. That hand
tool is actually a _press_.

Unlike crimping, I never have a binding or distortion problem.

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

I love to cook with wine Sometimes I even put it in the food

 

[Archimedes' Lever]

On Sun, 05 Apr 2009 22:02:57 +0100, Eeyore
<rabbitsfriendsandrelations@hotmail.com> wrote:

Archimedes' Lever wrote:

"ian field" <gangprobing.alien@ntlworld.com> wrote:
"Jim Thompson" <To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote

Command of the Queen's English?

BBC headline...

"Israelis shoot dead armed woman"


I've heard of a "dead leg" but not a dead arm.

The woman was dead, not her arm.

Dead, armed woman.

Requires an apostrophe you see.

Graham

That is a COMMA, you fucking retard!

Note also how headlines typically omit such punctuation thinking that
the average news reader has a modicum of common sense. I see most that
also frequent Usenet apparently do not.

 

[Archimedes' Lever]

On Sun, 05 Apr 2009 22:05:14 +0100, Eeyore
<rabbitsfriendsandrelations@hotmail.com> wrote:

Archimedes' Lever wrote:

krw <krw@att.bizzzzzzzzzzz> wrote:

I'm not AlwaysWrong, DimBulb.

Yes... You... Are... ALWAYS WRONG. Just like you were right there
by calling me by a name other than my own, you fucking retard.

Just how many aliases has the twit used ? How about a competition to list them all
?

Graham

Neither of those, you stupid fucktards!

 

[Archimedes' Lever]

On Sun, 05 Apr 2009 14:32:04 -0700, Jim Thompson
<To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote:

Those Ideal (brand) connectors are so easy to work with. That hand
tool is actually a _press_.

Unlike crimping, I never have a binding or distortion problem.

...Jim Thompson

Crimped or "pressed", they are BOTH still swaging operations, and they
are both still 'swaged" connections.

 

[krw]

On Sun, 05 Apr 2009 22:05:14 +0100, Eeyore
<rabbitsfriendsandrelations@hotmail.com> wrote:

Archimedes' Lever wrote:

krw <krw@att.bizzzzzzzzzzz> wrote:

I'm not AlwaysWrong, DimBulb.

Yes... You... Are... ALWAYS WRONG. Just like you were right there
by calling me by a name other than my own, you fucking retard.

Just how many aliases has the twit used ? How about a competition to list them all
?

Carl Sagan died counting.

 

[krw]

On Sun, 05 Apr 2009 13:48:28 -0700, Fred Abse
<excretatauris@invalid.invalid> wrote:

On Sun, 05 Apr 2009 07:16:25 -0700, bill.sloman wrote:

Probably

"Israelis shoot and kill an armed woman"

but it's longer than

"Israelis shoot dead armed woman"

and headlines have to be short.

So why not:

"Israelis shoot armed woman dead"

Exactly same character count.

How about "Israelis kill armed woman". Says everything important;
saves six characters.

 

[Jim Thompson]

On Sun, 05 Apr 2009 18:45:59 -0500, krw <krw@att.bizzzzzzzzzzz> wrote:

On Sun, 05 Apr 2009 22:05:14 +0100, Eeyore
rabbitsfriendsandrelations@hotmail.com> wrote:



Archimedes' Lever wrote:

krw <krw@att.bizzzzzzzzzzz> wrote:

I'm not AlwaysWrong, DimBulb.

Yes... You... Are... ALWAYS WRONG. Just like you were right there
by calling me by a name other than my own, you fucking retard.

Just how many aliases has the twit used ? How about a competition to list them all
?

Carl Sagan died counting.

Sno-o-o-o-ort ;-) Sagan was practicing to be a Democrat counting the
squandered money :-(

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

Lord protect me from queers, fairies and Democrats

 

On Apr 5, 10:48 pm, Fred Abse <excretatau...@invalid.invalid> wrote:

On Sun, 05 Apr 2009 07:16:25 -0700,bill.slomanwrote:
Probably

"Israelis shoot and kill an armed woman"

but it's longer than

"Israelis shoot dead armed woman"

and headlines have to be short.

So why not:

"Israelis shoot armed woman dead"

Exactly same character count.

Seems fine to me - it does split the infinitive, but ony pedants worry
about that.

--
Bill Sloman, Nijmegen

 

[Joe]

In article
<030e5831-5937-4d7f-ae78-659cec9ea54b@y9g2000yqg.googlegroups.com>,
bill.sloman@ieee.org wrote:

On Apr 5, 10:48=A0pm, Fred Abse <excretatau...@invalid.invalid> wrote:
On Sun, 05 Apr 2009 07:16:25 -0700,bill.slomanwrote:

<SNIP>

So why not:

"Israelis shoot armed woman dead"

Exactly same character count.

Seems fine to me - it does split the infinitive, but ony pedants worry
about that.

--
Bill Sloman, Nijmegen

I can just see the headline now:

Lisping Chef Shoots, Serves Pedant Under Glath

Sorry

--- Joe

 

[Ross Herbert]

On Sat, 4 Apr 2009 13:28:36 -0700 (PDT), gearhead <nospam@billburg.com> wrote:

:On Apr 4, 3:37 pm, Jim Thompson <To-Email-Use-The-Envelope-I...@My-Web-
:Site.com> wrote:
:> Command of the Queen's English?
:>
:> BBC headline...
:>
:> "Israelis shoot dead armed woman"
:>
:> Isn't it poor taste to shoot someone who's already dead ?
:>
:>                                         ...Jim Thompson
:> --
:> | James E.Thompson, P.E.                           |    mens     |
:> | Analog Innovations, Inc.                         |     et      |
:> | Analog/Mixed-Signal ASIC's and Discrete Systems  |    manus    |
:> | Phoenix, Arizona  85048    Skype: Contacts Only  |             |
:> | Voice480)460-2350  Fax: Available upon request |  Brass Rat  |
:> | E-mail Icon athttp://www.analog-innovations.com|    1962     |
:>
:> If we knew what we were doing, it wouldn't be called research...
:>                     -- Albert Einstein
:
:Headline in Conservation Quarterly:
:
:Armed Panda Enters Restaurant, Eats Shoots and Leaves.


In Aus the definition of a bloke referred to as a WOMBAT is someone who Eats,
Roots, Shoots and Leaves.
http://www.abc.net.au/schoolstv/animals/WOMBATS.htm

 

[Ross Herbert]

On Sat, 04 Apr 2009 21:55:24 +0100, Eeyore
<rabbitsfriendsandrelations@hotmail.com> wrote:

:
:
:Jim Thompson wrote:
:
:> Command of the Queen's English?
:>
:> BBC headline...
:>
:> "Israelis shoot dead armed woman"
:>
:> Isn't it poor taste to shoot someone who's already dead ?
:
:I doubt an apostrophe is required. Read your way though, it would only
:mean her arm was dead.
:
:Graham

It's known a Journalistic License. The inclusion of 'an' after 'dead' is
considered a waste of headline space.