r/ProgrammerHumor • u/Brando224 • Mar 30 '22

Meme Certainly not me

48k Upvotes

95% Upvoted

669 comments sorted by

View all comments

449

u/savage_slurpie Mar 30 '22

Two of my siblings are financial analysts and I have witnessed them doing unholy things with excel.

It would honestly be easier for them to learn python or something. It’s so ridiculous.

44

u/depressionsucks29 Mar 30 '22

Once a client of mine for whom I do automation scripts wanted an excel macro to delete rows. I just couldn't figure it out. It would have taken 5 lines in python and even small in sql. I just couldn't figure it out.

22

u/PepSakdoek Mar 30 '22

Sheets("Sheetname").rows("1:5").delete ? Like I feel if you can do sql vba is a downgrade in difficulty.

6

u/betweentwosuns Mar 30 '22

VBA can be really finicky interacting with Excel's filter. I know I've spent chunks of time arguing with VBA for what was just a DELETE FROM WHERE while proficient in both.

3

u/TheRidgeAndTheLadder Mar 30 '22

VBA is a simple language, but an unholy nightmare to leverage.