New to the site? Create an account →
Commenting on Don't change the Excel
keamoose
· Dec 13, 2017 at 5:14 pm
By the way, your IsNumeric code worked great, thanks :)
Commenting on Don't change the Excel
keamoose
· Dec 13, 2017 at 4:27 pm
You know what’s REAL FUN? Realizing that for the past 2 hours the entire problem has been a typo in a cell reference. Ok, back to the copper thing.
Commenting on Don't change the Excel
keamoose
· Dec 13, 2017 at 4:07 pm
Cool, I’ll give that a try!
I’m in deep trouble right now with a 2-dimensional lookup where I have to round the input in order to look it up. I AM LEARNING SO MUCH.
Commenting on Don't change the Excel
tcr!
· Dec 13, 2017 at 3:50 pm
Also, getting oneself in trouble is half the fun!
Commenting on Don't change the Excel
tcr!
· Dec 13, 2017 at 3:47 pm
I think you should be able to do something like…
Dim HardnessCheck As Boolean
HardnessCheck = IsNumeric(hardness)
If HardnessCheck Then
Copper = 👍
Else
Copper = 👎
End If
But keep in mind I haven’t been on Windows intentionally or in VB for literally years.
Commenting on Dec 8th, 2017 at 11:09:25 am
keamoose
· Dec 13, 2017 at 3:41 pm
H8ers gonna H8.
Commenting on Dec 8th, 2017 at 11:09:25 am
tcr!
· Dec 13, 2017 at 3:39 pm
What about E. coli O157:H8?
Commenting on The People of Alabama will do the right thing
tcr!
· Dec 13, 2017 at 1:51 pm
Yep, asshole indeed. I saw this on FB a few minutes ago:
Commenting on Don't change the Excel
keamoose
· Dec 13, 2017 at 12:12 pm
Haha, awesome :)
Do you remember any of it? I’d like to know how to make my function check whether the input is non-numeric, the issue being that the lab data it’s working with will sometimes have gaps in it, so the input cell might be blank or say ND (non-detectable) or something like <0.001 (less than the lowest amount the lab can measure). Right now I’ve settled for making the cell only accept numbers, but that will be a pain in the ass for entering the lab data because it won’t let you paste it in if it happens to be non-numeric. So, e.g. I have =COPPER(A1) and cell A1 is restricted to numeric data only, but I’d prefer that the COPPER function be able to check and return an appropriate value if A1 has something that isn’t a number or if it’s blank.
…I’m not a programmer. I know just enough to get myself in trouble. :P
Commenting on Dec 8th, 2017 at 11:09:25 am
keamoose
· Dec 13, 2017 at 11:59 am
Things water shouldn’t be:
1) Bitter
2) Stringy
3) Crunchy
4) E. coli O157:H7
Commenting on Don't change the Excel
tcr!
· Dec 13, 2017 at 11:54 am
VB was the first GUI-based programming language I learned. I wrote a basic web-browser in it once. Why? It was my own reading-Danish/Dave-liking experiment. 😊
Commenting on Junk is first then second
tcr!
· Dec 13, 2017 at 11:51 am
All Apple’s money seems to be going into hardware these days. Their software is going down hill.
Commenting on Dec 8th, 2017 at 11:09:25 am
tcr!
· Dec 13, 2017 at 11:47 am
But the CRUNCH!! 💥
Commenting on Be in love with someone.
jimi hindrance experience
· Dec 13, 2017 at 11:15 am
Commenting on Be in love with someone.
jimi hindrance experience
· Dec 13, 2017 at 11:14 am
Commenting on Be in love with someone.
jimi hindrance experience
· Dec 13, 2017 at 11:09 am
Some of these thoughts are anachronistic re; when I wrote ‘em. This was before I was all political and all. Christ, I was still murdering dates back then.
It was the best of times, it was the fuggin’ most bitchin’ purpendicular sawtooth waves of a time. Meet somebody, at a drive thru or over some counter somewhere; sometimes get set up on a blind date.
Anyway, when I was through, I’d always be lookin’ through their sock drawer for something to strangle ‘em with . Knee highs really don’t cut it unless you knot ‘em together. Thigh highs are perfect but if she had thigh highs I had ‘em on shortly after she quit wiggling and shit herself in a puddle of horror and shame. So there she was, all undressed and unable to blow. Stinkin’ like she’d just been savagely murdered and left for her room mate, away for the weekend, to find on Sunday about 5 ish.
Oops! That’s my mom. Or my wife. I’m slippin’ through these cracks like nobody’s business today.
Dearest Diary, more SOON!!!
← Previous Next → 9,911 Results — Page 366 of 496 Page 1 ← Page 11 ← Page 21 ← Page 31 ← Page 41 ← Page 51 ← Page 61 ← Page 71 ← Page 81 ← Page 91 ← Page 101 ← Page 111 ← Page 121 ← Page 131 ← Page 141 ← Page 151 ← Page 161 ← Page 171 ← Page 181 ← Page 191 ← Page 201 ← Page 211 ← Page 221 ← Page 231 ← Page 241 ← Page 251 ← Page 261 ← Page 271 ← Page 281 ← Page 291 ← Page 301 ← Page 311 ← Page 321 ← Page 331 ← Page 341 ← Page 351 ← Page 361 Page 371 → Page 381 → Page 391 → Page 401 → Page 411 → Page 421 → Page 431 → Page 441 → Page 451 → Page 461 → Page 471 → Page 481 → Page 491 → Page 496
tcr! · Dec 13, 2017 at 10:22 pm
Now they’re both in bed with me. #neveralone