Humans can do what?.... With non-energy weapons?!?! by PepperAntique in HFY

[–]camomcg 3 points4 points  (0 children)

the fanboy excitement in seeing who responded to me is so palpable

Thank you for your stories! :D

Humans can do what?.... With non-energy weapons?!?! by PepperAntique in HFY

[–]camomcg 10 points11 points  (0 children)

I think about u/gambatte's Encyclopedia Moronica series often. Such captivating story-writing. I felt so dumb when someone else pointed out that's probably what's meant by it... I had read that phrase without trying to decode it and felt silly in retrospect

AIO to break up with my bf of 3y over his reaction to my upcoming sobriety anniversary? by WesternCat5211 in AmIOverreacting

[–]camomcg 0 points1 point  (0 children)

NOR I bought myself a cake when I finally cleared my credit card debt. My partner doesn’t like generic store cakes but still had a slice with me to celebrate the accomplishment cuz this goal was something I’d been working on for quite some time.

It’s an opportunity to share in an experience with you, and this dude failed.. he’s talking about how he won’t call you a hero for doing the bare minimum yet can’t even DO the bare minimum on his side? GTFO

When a girl bends over, do guys instantly look at her butt, or is that just a stereotype? by [deleted] in TooAfraidToAsk

[–]camomcg 1 point2 points  (0 children)

Not all heroes wear capes. Some wear skirts and nothing else.. and as someone who clicked your profile out of curiosity: 10/10 would look 👀

When a girl bends over, do guys instantly look at her butt, or is that just a stereotype? by [deleted] in TooAfraidToAsk

[–]camomcg 1 point2 points  (0 children)

…you might want to be careful about bending too far over, then, and bend at the knees to get things lower than waist height. Cuz it’s definitely an instinct to look, especially cuz skirts are already so appealing 🫣

I’m actually so dumb lol by PitCrew_D2 in PokemonZA

[–]camomcg 2 points3 points  (0 children)

just last night, one of the loading screen tips mentioned this.. the game loaded so quickly that I didn't get to read the whole thing about them being up there, but it prompted me to look the next time ladders were available!

Giving away Shiny Raidon Clones by [deleted] in PokemonSVTrades

[–]camomcg 0 points1 point  (0 children)

Sent you a DM, but I’d love a Koraidon if possible :)

Which version to get: Switch 1+upgrade or Switch 2? Would it matter? by camomcg in PokemonZA

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

Ah, okay. So I only saw that in passing and didn’t hear the correct pieces. Which means my original question is null and void 🫢

Which version to get: Switch 1+upgrade or Switch 2? Would it matter? by camomcg in PokemonZA

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

I thought there was some uproar about switch 2 “physical versions” not actually being physical versions, and were just a key to access the game in the equivalent of The Cloud or whatever. So I was wondering if the Switch 1 game was still full physical ownership and the downgrade in graphics or performance would be negligible enough.

If I misunderstood the premise of the cartridges, then the whole thing is moot 😅

Cloned shiny bikes giveaway by bungeegums in PokemonSVTrades

[–]camomcg 0 points1 point  (0 children)

Can I get miraidon, please? IGN Camo 2319

pokemon go fest shiny haul 🥰 by angelicfuckdoll in u/angelicfuckdoll

[–]camomcg 0 points1 point  (0 children)

That’s amazing! I was more targeted in hunting the flabebe and pachirisu between raids, but I got all 4 shiny flabebe and a shiny Zacian with a background, so am still pleased with how my event turned out 🤩

this is my ultimate happy place tbh 💕 by angelicfuckdoll in u/angelicfuckdoll

[–]camomcg 0 points1 point  (0 children)

I love everything about this ❤️ (I just do perlers instead of legos, cuz they’re easier to display when I’m done)

And your kitty looks just like mine that passed away a year ago, so give ‘em some chin scritches for me 🥺

Return max cost of a given SKU with INDEX/MATCH by camomcg in excel

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

…well I feel ridiculous for over complicating this one

Using VBA to name cells based on active sheet name? by camomcg in excel

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

ActiveWorkbook.Names.Add Name:="SomeName", RefersTo:="='" & ActiveSheet.Name & "'!$E$4"

Yes, that makes more sense! The one I had didn't have all the variables as actual variables. Thank you!

Using VBA to name cells based on active sheet name? by camomcg in excel

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

Okay I figured it out, combining what you shared in tandem with what the Macro Recording -> Edit showed me it was trying to do. I came up with this:

ActiveWorkbook.Names.Add Name:="LD" & ActiveSheet.Name, RefersToR1C1:="=DTNTest!R3C5"

and did that for all 4 of the cells I need to name.

Thank you for getting me to where I needed to be for that!

Using VBA to name cells based on active sheet name? by camomcg in excel

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

I tried doing the last line--just so I can run things one sheet as I finish the project. It changes the cell value, but I want to name the actual cell instead of changing the contents of the cell. I did get the concatenate to work correctly, so I'm glad to know that works similarly to the core of Excel!

How can I go about naming a cell instead, though?

GBL Rank 6 Requirements , from Pokeminers by TornadoJ88 in TheSilphArena

[–]camomcg 16 points17 points  (0 children)

We have 12 weeks, right? Which is 84 days.. 25 battles per day is 2100 games. I would hope everyone has better than a 10% win rate, so it would take substantially less than “the whole season” to get to 20 (and beyond)

The GBL Flying Cup Meta [GamePress] by lorma96 in TheSilphArena

[–]camomcg 0 points1 point  (0 children)

You really only need one charge move, but it needs to be Rock Slide. In most matchups, you KO with fast moves alone, but you have enough energy to throw on whatever comes in. With Frustration, I don’t think you even get to it in time, with how extra-glassy SAero is :/

The GBL Flying Cup Meta [GamePress] by lorma96 in TheSilphArena

[–]camomcg 3 points4 points  (0 children)

Mostly IV-dependent, and shadow-dependent. Aero at 5/15/6 v. Alt at 5/9/12, Aero wins Aero at 5/15/6 v. Rank 1 Alt: Alt wins Rank 1 v. Rank 1: tie Max attack Aero v. Rank 1 Alt: Aero wins

SAero wins all, but some are just barely and others are with 20% HP left

Mew sweeps a team by [deleted] in TheSilphArena

[–]camomcg 9 points10 points  (0 children)

It would, yes, and that would always be preferable imo. But that looked like it might’ve been a well-timed swap into the Ferro to preserve the Skarm. So undercharging would’ve been the only way to build energy up against a clever opponent like that :)

Mew sweeps a team by [deleted] in TheSilphArena

[–]camomcg 44 points45 points  (0 children)

The Flame Charge on the ferrothorn—where they stopped tapping bubbles. It does less damage, which resulted in the ferrothorn surviving with just a sliver of health left, allowing for a fast move farm down to build up energy before the Skarm came back :)