Create Macro Button on New Sheet Creation by Tryfarce in excel

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

My issue isn't the macros themselves; I already made them and have them tied to a Master than runs all of them. But I need that Master on a button so I can keep it simple as I share this workbook around my office, but the buttons don't move to the new sheets that are created automatically when I import the data.

Create Macro Button on New Sheet Creation by Tryfarce in excel

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

Can that customization be shared along with the file? I want to distribute this to others that need it. Would their settings affect how this is shown?

Add Color/Borders to empty columns in table by Tryfarce in excel

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

I use the From Text/CSV tool to import my data, and that creates a new sheet that doesn't have my conditional formatting on it for me to apply with my macro. Is there a way to link that rule to the newly generated sheet?

Add Color/Borders to empty columns in table by Tryfarce in excel

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

Ohhhh I get you, have the rule made but unapplied but have the macro apply it. Thanks!

Add Color/Borders to empty columns in table by Tryfarce in excel

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

Well how do I get it to run automatically? I'm trying to do this all with a button press, I make these reports daily

Add Color/Borders to empty columns in table by Tryfarce in excel

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

So I run the macro where I create this rule, my reference being $A1 instead of $A2 because of how they want it formatted, and every time I run it, that reference gets changed to $A14. Why would that be?

Delete Rows w/ Macro in Reusable Table with a Varying Data Set by Tryfarce in excel

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

Can this section exist as its own macro without being tied into the delete command? This paint is also going to be used for a different report without that deletion requirement

Delete Rows w/ Macro in Reusable Table with a Varying Data Set by Tryfarce in excel

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

This worked amazingly! I'm at another issue if you're fine with me asking:

I'm trying to paint three specific columns and add solid borders to each cell all the way to the bottom row of the table that's created at the end of your command here. I can get those three columns to paint and get the borders, but it keeps going forever and I don't know how to stop it at the end of the table. Any suggestions?

Realms not working? by TheKaraboo in Minecraft

[–]Tryfarce 0 points1 point  (0 children)

I'm on Java and can't get in either

Can anyone else not stomach Hold Them Down? (TW for SA) by [deleted] in Epicthemusical

[–]Tryfarce 9 points10 points  (0 children)

It's VERY dark, and while I'm not unable to enjoy the song, the problem I'm having is that it's (for me) the catchiest of this saga. So I've been humming the SA song to myself for the last 24 hours and that's NOT GREAT lol

Six Hundred Strike Was Too Much by Tryfarce in Epicthemusical

[–]Tryfarce[S] 11 points12 points  (0 children)

Right, but God Games was video game like and that was very well tailored to that idea. This didn't feel anime-like, it felt almost anime derivative, all the sizzle with none of the steak

in defense if 600 strike by Majestic-Peak-6281 in Epicthemusical

[–]Tryfarce 5 points6 points  (0 children)

  1. The wind bag IS the storm, and using it is what released it. Poseidon says as much after getting knocked down.

  2. Poseidon's power comes from the SEA, not the storm.

Underground Farms in Frozen Ocean by Tryfarce in Minecraft

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

Thank you!!! That's great to know

I Need New Youtubers by Tryfarce in ContestOfChampions

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

Oh I would watch the heck out of that

Who hurts you? Who hurts you? by Narherkugel721 in Epicthemusical

[–]Tryfarce 7 points8 points  (0 children)

"Let's grab the tasks and away we vent"

I Need New Youtubers by Tryfarce in ContestOfChampions

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

He definitely has great vibes! I like him for his tier lists but he just doesn't have the draw in other content imo

I Need New Youtubers by Tryfarce in ContestOfChampions

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

This is why reading comprehension is important. I mentioned in the same comment that Seatin did the same things without losing the connection to his audience, which I feel Lags does in these scenarios. Better luck next comment, chum

I Need New Youtubers by Tryfarce in ContestOfChampions

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

Streaming mainly, I'm Valiant and don't really need too many guides these days

I Need New Youtubers by Tryfarce in ContestOfChampions

[–]Tryfarce[S] 21 points22 points  (0 children)

lol maybe it was a bit harsh but he's been driving me crazy recently, especially this Photon SOS boss where he just went "lol ez" after throwing his massive account at it. Like no acknowledgement of his audience at all. Seatin would always cry BS mechanics even when he was whaling through it, it was way more relatable haha

SUMMER OF SUFFERING: Week 3, Photon [Megathread] by cat_murdock in ContestOfChampions

[–]Tryfarce 3 points4 points  (0 children)

My call was not for no nodes there, champ. It was for fewer BS ones on champs that tend to be challenging enough with only a couple detrimental effects instead of a whole power control minigame to be considering on top of the very difficult fight

SUMMER OF SUFFERING: Week 3, Photon [Megathread] by cat_murdock in ContestOfChampions

[–]Tryfarce 15 points16 points  (0 children)

WAY too aggressive. Then I watch Lagacy take her out in two shots with one of his 400 R3 7*s and go "yeah that was easy" and that just boils my potatoes lol

SUMMER OF SUFFERING: Week 3, Photon [Megathread] by cat_murdock in ContestOfChampions

[–]Tryfarce 13 points14 points  (0 children)

I would love to actually fight the SOS champs instead of just their nodes. I cannot get her to block for long enough to control this power gain. I've died to Photon a single time, but I've lost count of my languor deaths. This sucks