What is the best AI to use for updating VBA? I’m not familiar with VBA, so I’ve been using ChatGPT 5.2 Thinking to help me update some old macros, but the response time and results have been disappointing.

like
Posting as :
works at
You are currently posting as works at

I've used chatGPT successfully for VBA. But I also know VBA so I'm probably a little more specific with my prompts.

like

I think I found a better option. Anthropic Claude was able to resolve an issue on the first try in just a few seconds that ChatGPT wasn’t able to resolve in 2 hours (it gave me multiple solutions that didn’t work).

like

Not be what 2mdem7detxwx8t8ji8hs2tm eh

like

AI can help with VBA, but the bigger issue is usually that old macros weren’t designed to scale or be maintainable.

If you’re updating legacy code repeatedly, it might be worth stepping back and asking whether the workflow should be refactored (Power Query, structured tables, or even external scripting feeding Excel).

Is this a one-off fix or something that breaks regularly?

Related Posts

On the chopping block. actively looking. anyone hiring?

Hi, my I485 is pending. Priority is July 2014 EB3. I-485J is for a software developer but I moved to different role (HR) within the same company. How will it affect my GC processing? Is there a way I can move to a different company in HR? Or is it best to stay with the same company until I get my GC?

like

I need an opinion, which field is better in terms of compensation and work/ life balance , a sales producer or adjuster ??

like

So I used to work for a company where my job was good, was a director of business solutions for a fashion brand. Only issue was that the CFO micromanaged and ended up leaving. My background is digital transformation however I took an infrastructure position to rebuild a provincial healthcare system. I always lacked the hardware side and thought this was a good move but I feel like I’m losing my digital skills and don’t enjoy the work. I’m in it for 7 months now.

like

My yearly appraisal in on the way. I worked for the same client for the last year but in 3 different projects. I received client appreciations in all 3 projects and in addition I also helped my account in creating proposals, etc. What should I expect in terms of rating and monitory appraisal. Would be thankful to any genuine advice.

like

Need help !!

Can Anyone from ICICI bank help get a transaction details of a person who is been missing for few days now ??
Location Mumbai

Bacon cheeseburger soup (with ground turkey)

Post Photo
like

What is the salary hike you aim for when negotiating compensation with a new company? I’ve talked to a few and ultimately passed because none of them are meeting the 30% increase I’m looking for. Are companies already starting to be stingy again or am I looking in the wrong place?

like

Deloitte GPS offer: human capital consultant.
5k sign on, 88k base, 13% target bonus. Good offer?
1 year of consulting experience, 1 year of industry.

like

Applied to Monitor Deloitte for SC in Corporate & Digital Strategy, currently in 'interview/assessment' stage, too late to grab a referral? Or can anyone help me out?

like

Internship Program Help: Hi Everyone! I’ve never worked for a company with any type of internship program at all, let alone a really successful one. My new company thrives off our internship program, with many of our managers/directors having started as one themselves. I’d like to create more of a structure to this program but not even really sure where to begin. Also don’t want to bite off more than I can chew, but would love to hear some tips or even better, maybe have a quick chat if willing?

like

Need some advice. During May of 2021 an operations manager and an hourly Hr employee started a relationship while the ops manager was married. We had supervisors give us pictures of those two kissing at workFast forward they are now engaged and getting married. The HR worker does not work here anymore since July 2021. Is it too late to investigate the ops manager for misconduct ? The ops manager has worked here for 15 years and is super valuable, the operation literally can not run without him.

like

Honest answers only: what got you interested in this industry? Do you enjoy your work?

helpful

I’m starting to slowly get into product marketing at my job, eventually fully transition in product marketing. I’d love to get some advice on how to best work with a product team and build a relationship. Seems like our product is never quite ready (new features, updates, etc)

like

As a Senior Java Developer with 7.5 yrs experience what would be the expected CTC at Amazon(SDE2) and Walmart(SDE2)?

like

Paytm: can i copy your homework ?
Ola: Yes but don't make it too obvious
Paytm: sure.

Post Photo
funnylike

Late stage analyst 1 at a mid-market heavy TMT focused M&A boutique in London. Keen to increase exit opps and realise it may be worth trying to lateral to a BB / name brand. Any opinions / advice on achievability? If low, what’s the best move here.

like

I have a meeting with a CEO of a start-up IB. She is meeting to help guide me in the industry (not just a job interview). What questions would you ask?

like

I don't understand the point of hiring candidates. Its been more than two months and i am sitting idle. There is no updates from management. I am getting info like i will get half salary this month because of the bench policy. I m confused what to do next

like

Additional Posts in Excel Genius

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Any book recommendations on excel modeling for real world business applications?

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Hi there,
Which Excel courses you recommend for a beginner?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Anyone know what these badges are?

Post Photo
likefunny

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal