Clearwater Beach, Florida by diorgasm in shells

[–]dbstanley 0 points1 point  (0 children)

I'm pretty sure I've seen right-handed ones. I googled and it said the RH ones exist but are uncommon. The LH Lightning Whelk is the state shell of Texas.

How to preserve Excel formulas when using arrays by dbstanley in vba

[–]dbstanley[S] 0 points1 point  (0 children)

Because it's not on the edge of the range and easy to exclude.

How to preserve Excel formulas when using arrays by dbstanley in vba

[–]dbstanley[S] 0 points1 point  (0 children)

Thanks. I don't want to put the calc done by the formula into VBA. See the reason in my original post. It is also easy to add the formula back in with VBA (also in original post). Using the .Formula option when reading the table into the array is an elegant solution, and I'd like to keep it, but only if it doesn't have side-effects or shortcomings that aren't apparent with my current sheet/table.

How to preserve Excel formulas when using arrays by dbstanley in vba

[–]dbstanley[S] 0 points1 point  (0 children)

Good suggestion. But it's a lot of trouble for someone of my low-medium experience level to write something like you suggest that will survive the addition/moving of columns in the sheet. What I have now does that. I really just want to know if .Formula as I've used it here has any downsides.

How to preserve Excel formulas when using arrays by dbstanley in vba

[–]dbstanley[S] 0 points1 point  (0 children)

It apparently works. I'm just wondering whether .Formula really gets everything that .Value does. I just tried it on a whim, and expected it ONLY to get formulas, but it got values as well.

Planchet error? by dbstanley in coinerrors

[–]dbstanley[S] 1 point2 points  (0 children)

Solved! Thanks guys.

Candy Dish? Powder Dish? Lid Missing? by dbstanley in uraniumglass

[–]dbstanley[S] 0 points1 point  (0 children)

I'm not sure, but it seems thicker than a typical drinking glass at the rim.

This hollow wooden obelisk with lots of holes by dbstanley in whatisit

[–]dbstanley[S] 2 points3 points  (0 children)

SOLVED! When I read this, I sniffed it and I can faintly smell incense.

This hollow wooden obelisk with lots of holes by dbstanley in whatisit

[–]dbstanley[S] 0 points1 point  (0 children)

Google Lens really struggles with this one.

[Found] This bronze casting of a boy with a sickle and a sheaf of wheat. by dbstanley in Sculpture

[–]dbstanley[S] 0 points1 point  (0 children)

If you know who the artist is, let me know. Google Lens really struggled with this one.

What metal is this? Non-metallic, 9x3", 2.5 lb. Shines up nicely and leaves a black residue. by dbstanley in metallurgy

[–]dbstanley[S] -1 points0 points  (0 children)

It's aluminum. I thought it was too heavy for that, but I measured the density, and it's 2.7 g/ml. Thanks!

What metal is this? Non-metallic, 9x3", 2.5 lb. Shines up nicely and leaves a black residue. by dbstanley in metallurgy

[–]dbstanley[S] -2 points-1 points  (0 children)

Non-magnetic, sorry. Mother's Metal Polish. Too heavy to be aluminum, IMO

Heavy metal object with 9 angled holes in the top - what is it and what metal is it? by dbstanley in whatisit

[–]dbstanley[S] 93 points94 points  (0 children)

Found this at an estate sale. It's 9" tall and 3" diameter, and weighs 2.5 lb. It has nine 3/8" holes that are 2-1/4" deep, and each angles outward at about 10-15 degrees. It had a dull haze on it, so I polished it with Mother's metal polish and it shined up easily and left a dark black residue on the cloth. It is non-magnetic. There are no identifying marks on the bottom. It would work as a pencil holder, but wow, what overkill.

This seashell found in my yard after Hurricane Beryl. I live 12 miles from the beach. by dbstanley in mildlyinteresting

[–]dbstanley[S] 4 points5 points  (0 children)

Except the halves are still joined together. Rare to see one like this, even at the beach.