Jump to content

NWBuck

Legacy Members
  • Posts

    4615
  • Joined

  • Last visited

Everything posted by NWBuck

  1. That's awesome... I don't let our dog sleep on the living room couch, let alone a spider.
  2. This is my situation, on two levels- the "we need a system" and the "let's buy lots of this bullshit cooking ingredient that we only need one tablespoon of because we may use it in the future" genes. For column A, my response is "The problem isn't the lack of a system, the problem is that none you believe it's not just easier to jam stuff back in the cabinet when you're done with it". Luckily, I have a box in my garage filled with remnants of three different "systems" that all ended up in the house under the guise of "But if I get this new thing, it'll motivate me to keep using it." Unfortunately, that same logic gets shot down when included in my casual appreciation for her very attractive co-worker (no pics). Column B is managed by my throwing away one box/container of the bullshit every two weeks. I'd like to report that no one notices, but I did have to deal with the "See! My new system works- look how much less crowded the cabinets are!" Which then led me again to retrieve the system in question from the box in the garage.
  3. Because your 'right' example was football related, I thought this said Ron Dayne (which would have made it technically correct)
  4. Really good thread on this from earlier this morning... Author wrote a new book about the topic. https://threadreaderapp.com/thread/1790332531872546844.html
  5. Any intercourse with Boebert is fucking an asshole
  6. 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)
  7. 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.
  8. A few photos from Seattle in the pictures post, but here's another
  9. Interesting night in Seattle
  10. 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 = True If 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
  11. That's Garrison Keillor
  12. 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?
  13. <squeaky noises and chaos> "Your lower intestines!" (still the way I make balloon animals).
  14. She's absolutely one ugly muga fuga.
  15. Their Christmas/Winter album is a constant part of December in our house
  16. Hmmm... If "crabcakes and football" is what Maryland does, and we've seen the quality of their football...
  17. "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/
  18. 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
  19. This is fun...
  20. 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/
×
×
  • Create New...