The Daily WTF: Curious Perversions in Information Technology

2014-05-08 Reply Admin

chubertdev:
So for these tests:
(English) =0>1 =0<1 =1>0 =1<0 TRUE FALSE

(Swedish) =0>1 =0<1 =1>0 =1<0 TRUE FALSE

Do you get the same results?

Yes, I do. And now I have a test for you:

(English) 10-11-12

(Swedish) 10-11-12

Now, tell me, how is Excel supposed to read your mind and do what you expected, rather than obey the regional settings you've defined?

2014-05-09 Reply Admin

F:
n_slash_a:
Jay:
QJo:
For the non-XL-experts among us: anyone going to write how the code ought to be?
Sure.
Private Sub Worksheet_Calculate() [A1].Name = "paula" [paula] = "Brillant" End Sub

That will be $200, thanks.

(I make a living from this sort of stuff too, so please keep doing it.)
FTFY

FTFY

FTFY.

As an aside,Worksheet_Calculate() is an event that fires when you edit a cell, a WTF bonus.

/Saluto!

2014-05-09 Reply Admin

Jay:
F:
n_slash_a:
Jay:
QJo:
For the non-XL-experts among us: anyone going to write how the code ought to be?
Sure.
Private Sub Worksheet_Calculate() [A1].Name = "paula" [paula] = "Brillant" End Sub

That will be $200, thanks.

(I make a living from this sort of stuff too, so please keep doing it.)
FTFY

FTFY

FTFY.

As an aside,Worksheet_Calculate() is an event that fires when you edit a cell, a WTF bonus.

/Saluto!

What will that do if a cell named "paula" already exists elsewhere in the worksheet? Say, for instance, that "paula" moved...

2014-05-09 Reply Admin

anonymous:
Jay:
F:
n_slash_a:
Jay:
QJo:
For the non-XL-experts among us: anyone going to write how the code ought to be?
Sure.
Private Sub Worksheet_Calculate() [A1].Name = "paula" [paula] = "Brillant" End Sub

That will be $200, thanks.

(I make a living from this sort of stuff too, so please keep doing it.)
FTFY

FTFY

FTFY.

As an aside,Worksheet_Calculate() is an event that fires when you edit a cell, a WTF bonus.

/Saluto!
What will that do if a cell named "paula" already exists elsewhere in the worksheet? Say, for instance, that "paula" moved...

There is only, and can only, be one Paula.

It's like Highlander, only Brillant.

2014-05-09 Reply Admin

Jay:
anonymous:
Jay:
F:
n_slash_a:
Jay:
QJo:
For the non-XL-experts among us: anyone going to write how the code ought to be?
Sure.
Private Sub Worksheet_Calculate() [A1].Name = "paula" [paula] = "Brillant" End Sub

That will be $200, thanks.

(I make a living from this sort of stuff too, so please keep doing it.)
FTFY

FTFY

FTFY.

As an aside,Worksheet_Calculate() is an event that fires when you edit a cell, a WTF bonus.

/Saluto!
What will that do if a cell named "paula" already exists elsewhere in the worksheet? Say, for instance, that "paula" moved...
There is only, and can only, be one Paula.

It's like Highlander, only Brillant.

I know there can be only one, but it's entirely possible that "paula" can move. Say, for instance, that you insert a new row or column at the very top or very left of the worksheet, or for some reason you cut and paste her cell to another location. Will your VBA now crash and burn when it tries to create another cell named "paula" in A1?

2014-05-09 Reply Admin

anonymous:
Jay:
anonymous:
Jay:
F:
n_slash_a:
Jay:
QJo:
For the non-XL-experts among us: anyone going to write how the code ought to be?
Sure.
Private Sub Worksheet_Calculate() [A1].Name = "paula" [paula] = "Brillant" End Sub

That will be $200, thanks.

(I make a living from this sort of stuff too, so please keep doing it.)
FTFY

FTFY

FTFY.

As an aside,Worksheet_Calculate() is an event that fires when you edit a cell, a WTF bonus.

/Saluto!
What will that do if a cell named "paula" already exists elsewhere in the worksheet? Say, for instance, that "paula" moved...
There is only, and can only, be one Paula.

It's like Highlander, only Brillant.
I know there can be only one, but it's entirely possible that "paula" can move. Say, for instance, that you insert a new row or column at the very top or very left of the worksheet, or for some reason you cut and paste her cell to another location. Will your VBA now crash and burn when it tries to create another cell named "paula" in A1?

Nah.

If you insert a row, then 'paula' will now refer to A2.

If you then set [A1].Name = 'paula', that becomes 'paula'. No complaints from Excel or VBA. Of course you may have actually wanted the value in A2, but now that 'paula' refers to the wrong spot, well too bad.

FWIW 'Named Ranges' can can be global (workbook) or local (worksheet), so a book with three sheets can have four 'paula' ranges in there. The global name trumps the local one, so ='paula' may not get the answer you were expecting.

Oh what an I saying, they'd all be 'Brillant'.

2014-05-24 Reply Admin

The beauty of Microsoft VBA is that anyone good piece together code to accomplish whatever his/her mind could think of without having years of coding education or training. The purpose of the product was to unleash the creativity of the average everyday user without having to be dependent on a professional coder every time a change was needed. I have great respect for professional coders, they are like magicians. But professional coders lack the corresponding respect for average everyday people who tried the hardest to make a product work for them as best they could. Instead of mocking the example code, show a little respect for the time and energy needed to create the solution to a problem as it existed at the time.

2014-05-25 Reply Admin

Bruce:
The beauty of Microsoft VBA is that anyone good piece together code to accomplish whatever his/her mind could think of without having years of coding education or training. The purpose of the product was to unleash the creativity of the average everyday user without having to be dependent on a professional coder every time a change was needed. I have great respect for professional coders, they are like magicians. But professional coders lack the corresponding respect for average everyday people who tried the hardest to make a product work for them as best they could. Instead of mocking the example code, show a little respect for the time and energy needed to create the solution to a problem as it existed at the time.

Hmm, trolling or just stupid?

Bruce old son, you need to read this comment: http://thedailywtf.com/Comments/Giving-Excel-the-RunaRound.aspx#432754 which explains the much deserved mocking.

2014-05-27 Reply Admin

Bruce:
The beauty of Microsoft VBA is that anyone good piece together code to accomplish whatever his/her mind could think of without having years of coding education or training. The purpose of the product was to unleash the creativity of the average everyday user without having to be dependent on a professional coder every time a change was needed. I have great respect for professional coders, they are like magicians. But professional coders lack the corresponding respect for average everyday people who tried the hardest to make a product work for them as best they could. Instead of mocking the example code, show a little respect for the time and energy needed to create the solution to a problem as it existed at the time.

I have a lot of respect for a self-taught musician who's given a nice piano and writes a legit symphony. Not so much for the self-taught carpenter who's given a nice computer and uses it as a hammer. If you're given a nice tool, figure out how to use it well, or at least well enough to not create a complete mess. Then I'll respect you.

2023-08-07

Comment held for moderation.

Giving Excel the Run-a-Round

Leave a comment on “Giving Excel the Run-a-Round”