Jump to content

NWBuck

Legacy Members
  • Posts

    4819
  • Joined

  • Last visited

Everything posted by NWBuck

  1. A few photos from Seattle in the pictures post, but here's another
  2. Interesting night in Seattle
  3. 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
  4. That's Garrison Keillor
  5. 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?
  6. <squeaky noises and chaos> "Your lower intestines!" (still the way I make balloon animals).
  7. She's absolutely one ugly muga fuga.
  8. Their Christmas/Winter album is a constant part of December in our house
  9. Hmmm... If "crabcakes and football" is what Maryland does, and we've seen the quality of their football...
  10. "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/
  11. 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
  12. This is fun...
  13. 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/
  14. Yup. Except the ones in Seattle are about 2/3 the size and no yard or acreage for the same price.
  15. I think that's a sign of their posse's insanity?
  16. Just going to add this... 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).
  17. Yes, I would eat her.
×
×
  • Create New...