-
Posts
4229 -
Joined
-
Last visited
Content Type
Profiles
Forums
Store
Downloads
Recruiting - 2020
2019-2020 Football Season
Football
Entertainment
Sports
News and Business
Cloak Room
Transfer Portal
Recruiting
Events
Posts posted by NWBuck
-
-
Dana Gould covers Corman's career midway through his latest podcast
https://www.danagould.com/hecks-angels/
(which is also worth the listen for the Phil Hendrie stuff)
-
OK, @Dahobbs, new question...
I've got a database where folks are filling in information, but there are a lot of categories that are blank. (Specifically, we're hiring, and my database shows all the positions- my staff updates demographic info when the positions are filled)
I've got another table which pulls out limited info (name, position, pay rate), and I'd prefer that Finance wouldn't have to wade through all the blank rows (open positions).
Is there a way to create a table that hides rows if one cell (last name, for instance) is empty/blank and then unhides the row if that cell gets updated?
I'll hang up an listen.
-
3 hours ago, ajax said:
- 2
-
-
-
4 hours ago, Dahobbs said:
Post the code.
Borrowed from an online forum, adapted for my parameters:
Private Sub Worksheet_Change(ByVal Target As Range)
' define Timestamp output column
Const TimeStampColumn As String = "I"
' Observe C2:E1048576 for changes
Dim RangeToObserve As Range
Set RangeToObserve = Me.Range("A3:E" & Me.Rows.Count)
' Get all changed cells within the observed range
Dim ChangedCells As Range
Set ChangedCells = Application.Intersect(Target, RangeToObserve)
If Not ChangedCells Is Nothing Then
Application.EnableEvents = False
On Error GoTo ENABLE_EVENTS ' make sure in case of errors events get enabled!
Dim Row As Variant ' write timestamp for every changed row
For Each Row In ChangedCells.Rows
With Me.Cells(Row.Row, TimeStampColumn)
.Value = Now()
.NumberFormat = "dd\/mm\/yyyy hh:mm"
End With
Next Row
On Error GoTo 0
End If
ENABLE_EVENTS:
Application.EnableEvents = TrueIf Err Then
' make sure to raise the error otherwise it will be silent and you will never notice that anything went wrong.
Err.Raise Err.Number
End If
End Sub -
-
OK, I'll play...
Excel sheet with a macro to datestamp when a cell in the row changes.
Can't get it to fire when a cell auto-fills in response to another sheet being updated (using xlookup). So, the cell isn't empty (per se) since it's got that formula in it. But I'd like it to datestamp when it goes from blank to showing data.
Thoughts?
-
<squeaky noises and chaos>
"Your lower intestines!"
(still the way I make balloon animals).
- 1
-
12 hours ago, Brisketexan said:
One can't blame her for wanting to Make Ugly Great Again.
She's absolutely one ugly muga fuga.
- 1
-
Their Christmas/Winter album is a constant part of December in our house
-
On 4/27/2024 at 7:03 PM, Ignatius said:
Maryland crab cakes rule ass…
Hmmm... If "crabcakes and football" is what Maryland does, and we've seen the quality of their football...
-
13 hours ago, ChuckNorrisActionJeans said:
We ArEn't a DEMocracY LibTAARD!!11 IT's A coNStiTuTionAL RePUbLIC huurrrr durrr
I see this stupid talking point almost every fucking day. No, they don't support democracy.
"BE IT FURTHER RESOLVED that we... oppose legislation which makes our nation more "democratic" in nature, and that, while we favor and encourage liberty in all 30 nations, we oppose all efforts to use American military might to spread "democracy" around the world."
Your Washington State Republican party, folks...
https://www.seattletimes.com/seattle-news/politics/the-wa-gop-put-it-in-writing-that-theyre-not-into-democracy/- 2
-
Things that started out as "oops" but now are the way I pronounce things to embarrass my daughters in front of their friends:
- "luh-VAN-dur" = Lavender
- "ren-day-ZEE-voose" = Rendezvous
- "extra ordinary" (break between words)= Extraordinary
- "kuh-RAM-muhl" = caramel (as a counter point to the "car.mel" and "care.a.mel" debate)
- Given the previous, was a big fan of "kuh-RAM-muh-low" in the early 2000s
- 1
-
This is fun...
- 1
- 2
- 1
-
3 hours ago, YGIFS said:
I can't watch pornhub in Texas, but I can watch the head of the RNC discuss anal sex on live television?
And we don't love inside stimulation? Got it.
Fixed
- 1
-
Good question- Lots of places to eat and shop and stuff right near the Bainbridge landing area, so you could probably get away with just walking.
You might consider renting a bike if you want to tour around a bit more (https://www.bikebarnrentals.com/)... I always try to go the the Exclusion Memorial when I go over to the island (with my car): https://www.nps.gov/miin/learn/historyculture/bainbridge-island-japanese-american-exclusion-memorial.htm
Here's a few resources:
- https://www.destinationbainbridge.com/blog/bainbridge-island-activities/bainbridge-island-without-a-car/
- https://wheatlesswanderlust.com/day-trip-bainbridge-island/
- 2
-
16 minutes ago, RDCanecutter said:
I like to think that there is a semi-liquid poop pool down at the asshole, so that farts percolate up through it like pot smoke through bong water, except maybe with different effects.
- 2
- 1
-
-
10 minutes ago, Gil Bang said:
45 degrees in the courtroom y'all.
"We're only honoring the 45th President!"
("and trying to keep the stench down by freezing it")
-
7 hours ago, Red Five said:
"Nuh uh! Thank you your honor." (sits down)
5 hours ago, C-Man said:Lies upon lies upon lies ad nauseum
They should let Trump serve as his own lawyer... you know, with his big brain and all that.
- 2
-
23 minutes ago, Pato del Muerto said:
If you’re cool with million dollar house prices. But I guess if you are comfortable in Seattle proper, you would be.
Yup. Except the ones in Seattle are about 2/3 the size and no yard or acreage for the same price.
-
1 hour ago, 52-80 said:
Why were the insane clown posse ever a thing
I think that's a sign of their posse's insanity?
- 1
-
22 hours ago, otisdog said:
Pretty sure that the Lynnwood extension opens August 30.
Just going to add this...
On 4/20/2024 at 6:44 AM, gmr548 said:Our initial inclination is to look for a place in north Seattle convenient to I-5 and rail. Greenwood, Maple Leaf, Northgate, Green Lake, Roosevelt, something like that. Any thoughts on whether that counter-commute is doable? Evidently there are some staff that live in north Seattle and say it's not bad. I definitely prefer an urban location like that but I work remotely, I'm not the one commuting. Honestly I could compromise on an inner ring suburban location like Shoreline or Mountlake Terrace as long as it's convenient to I-5 + the coming rail extension. I worry that commuting from North Seattle will suck for her despite it being a counter commute but my wife is pretty set on living in Seattle proper as a base to get to know the region better.
If you can get past the need to live in Seattle proper, being in Edmonds would be pretty sweet- close to Everett and a quick jaunt down to Seattle if you wanted. Bothell or Montlake Terrace (as you mentioned) might also work (Snohomish county for tax purposes).
If you were open to something more rural/small town, Snohomish is pretty nice, and I have a lot of friends who really like Woodinville (lotta wineries and such in that area).
- 1
Lauren Boobert - Tits and a Gun
in Cloak Room
Posted
Any intercourse with Boebert is fucking an asshole