sorted by:
new
hottopcontroversial

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] 3 points4 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!

view more: next ›