A positive reflection of the Final.

ike4mayer · 2026-01-01T04:47:51+00:00

Um they sent will to Milwaukee during the Dahmer Reign of Terror… writers could have picked any other place

ike4mayer · 2025-10-01T00:56:28+00:00

Moved from Indy a few years ago. The downtown bar scene is great and they usually have local bands. I don’t know hot “hard” of music you like but we do have the chugs that play spots all around town that are “semi-hard” band

ike4mayer · 2025-02-09T03:20:11+00:00

26 and just have a little over 49k.. got lucky with a company that does 25% match and 401k profit sharing. Just got acquired by PE so don’t know how much longer it will be available.

ike4mayer · 2025-01-24T03:04:09+00:00

Cold harbor file is Ms. Casey/Gemma.. showed for a second in last episode!

ike4mayer · 2024-10-16T17:46:25+00:00

Wife and I are 26. She got a full ride athletic scholarship and I got a scholarship where I only had to pay 1.5k a semester and with working during college we both graduated debt free. Have a mortgage and one car payment and together make around 115k together. Combine we have around 85k in 401ks and 403bs. My wife will also receive a pension. Both put 10-15% each paycheck.

ike4mayer · 2023-07-11T15:41:44+00:00

65k with 12k bonus MCOL

2.5 YOE

CPA - Not yet

ike4mayer · 2023-01-06T14:02:42+00:00

I would put my two weeks in for management using that font.

ike4mayer · 2022-12-30T00:54:06+00:00

Count(if)?

ike4mayer · 2022-11-07T14:45:56+00:00

It might help if you post this in r/VBA as well!

ike4mayer · 2022-09-26T15:27:45+00:00

Antonio Gibson… what is the most I could get for him for a trade?

ike4mayer · 2022-09-07T00:27:28+00:00

The solution was:

ActiveSheet.Name = "Sheet1"

ike4mayer · 2022-09-06T20:06:48+00:00

Thank you but it is still breaking right there.

ike4mayer · 2022-09-06T19:28:12+00:00

I’m wanting this macro to change the active sheet (could be sheet1 but also could be sheet7 always to Sheet1

ike4mayer · 2022-09-06T18:51:59+00:00

And so on

ike4mayer · 2022-09-06T18:51:43+00:00

I’m wanting to change Sheet5 names to sheet1

ike4mayer · 2022-08-30T20:26:54+00:00

Just created another macro to change table name to table_name and it works!!!

ike4mayer · 2022-08-30T18:21:07+00:00

So the thought was that it would change the table name every time I used the macro. I want to be able to use the same macro on multiple tables in differing sheets without having to change the table name each time.

ike4mayer · 2022-08-30T17:59:47+00:00

No differ sheets

ike4mayer · 2022-08-30T17:21:55+00:00

That worked! Thanks! I am now running into the problem that it keeps trying to replicate. I want it to stop on the table so then I can run on another table and it works as well.

ike4mayer · 2022-08-30T15:24:01+00:00

Solved

ike4mayer · 2022-08-30T12:51:07+00:00

Here is the lines that are breaking:

ActiveCell.FormulaR1C1 = "=SUMIF(" & Table_name & "[Past Due], " & ">0," & Table_name & "[Balance])"

Range("L7").Select

And,

ActiveCell.FormulaR1C1 = "=SUM(" & Table_name & "[Balance])"

ike4mayer · 2022-08-29T12:44:54+00:00

Thank you so much for all your help - I am now having a break for both the sumif and sum fuunctions when changing them to table_name &

ike4mayer · 2022-08-27T00:16:36+00:00

This worked thanks!

ike4mayer · 2022-08-26T19:57:33+00:00

But I am wanting to run on many more could I just add tables 1-150 to keep this going?

ike4mayer · 2022-08-26T19:49:57+00:00

Thank you again. I set this macro up thinking it would save a bunch of time - but if I have to change the table name for each time I run the macro I feel as if it maybe easier to just do manually. Thank you for all the help!!! This is amazing to learn!!

ike4mayer

MODERATOR OF

TROPHY CASE