Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

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

Shot in the dark here but are there any functions / ranges referencing another file? That might cause an issue with macros

like

Is the macro trying to read information from a resource on a network share that maybe you have access to but the other 2 don't?

like

There can be several causes for this.

If you are using an object that hasn't been created yet, so on your setup it was correct and on theirs it is missing.

If the object or variable has been set to nothing or null

If the set is not present or omitted when the variable is assigned or if you are using a "GoTo" to enter that block or function.

There are others but those are most common.

It's likely some object missing on their end and not yours.

Related Posts

I have an offer from TCS of 7.5 CTC. To retain, my organisation has promised to send me onsite(Poland) in a few months with 3 times my current CTC(3.35LPA).
Should I revoke my offer and stay or switch? I still have 1.5 months of my notice period left so I’m aiming to get more offers and increase package till 15LPA. I have 2.5 YOE.

like

What's the highest salary for Associate Lead Data Scientist ? Sigmoid analytics Sigmoid

like

Hi, one of my friend wants to move from network engineering domain to devops having around 2.5 years of experience. How can he make an easy shift. What all companies can he look forward to.

like

Moving to Chicago from Boston at the end of the month! Signed a lease in River North at WPE. Any tips for getting acclimated, dos and don’ts? This is my first move and although I’m excited, I’m a little nervous to be in a brand new city. For context 29 F.

like

Hello fishes. If interested in the below opportunities in Automotive mechanical and embedded domain, please DM your resume.

#automotive #embedded #mechanical #design

Post Photo
like

Boy do I wish I hadn’t left my HBS app to Jan 5th evening

likefunny

Hello fishes Openings available Dover Corp. Interested people can dm me

Post Photo
like

Hi Sharks,

Is a bond for 2 years valid if the company has not provided any training or has spent money on training?

Any help regarding this topic will be appreciated.

like

So, I literally have ZERO friends. I moved to the US when I was 19, lost touch with a few childhood friends. Didn’t make too many friends in college. And now I am 33 and married, with ZERO friends.

Looking to connect with someone from ZS- specifically market access. Trying to get my hands on a pdf of a book written by Ed Schoonveld.

Thanks!

like
like

Hi all,
It seems everyone is successful here expect me.
Due to some family problem left my study.
have failed in every interview after telling about my qualifications .
don't know how to overcome this
have overall 10 Year Experience in IT with Industry like , Philips,AIIMS , Shangri-La hotel, National physical lab,Delhi High Court .
I am a self made person learn things very quickly also love to learn new things.right now I am pursuing Citrix but I guess it's not worth it due to my qualification

like

What CTC i can expect if i have 2 year experience as a java developer or network engineer?

like

Hi all please help me understand ,

I have joining in Dec at IBM. Today I have received below email :
Please allow 1 business day for your pre-hire tasks to populate your profile and be aware tasks will appear in groups. As you complete each group, new tasks will appear.

Is there any other technical round/task which one has to clear before onboarding.
Please suggest

like

Heads up for any Target shoppers and Discover card holders. Target gift cards are 10% off today only. Stack that with the 5% Discover cash back at Target, you’re getting it at a 14.5% discount

like

Good morning you wonderful fishies!
Have a question around SF Sales Could Einstein. We are preparing to launch a Pilot with around 65 of our sales reps and managers.

We can't launch all the features due to compliance and configuration issues:
Activity Capture
Analytics App
Automated Contacts

Have any of you launched Einstein?
Was it a success?
Have your teams seen the value?
What KPI's did you use to measure adoption and the validity of the insights generated?

Thanks in advance for your input

like

Any good moving companies to move from socal to NorCal?

like

Standing desk owners - what % of time do you roughly sit vs stand?

like

If you’re a SQL expert, plz plz comment so I can message you about a query I need help with. Thank you!

like

My hometown is a ghost town between the 26th and 31st apparently

like

Additional Posts in Excel Genius

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

I run a chatbot that collects students inquiries and want to spot reoccurring questions without going through all 4,000 questions. So far, I’ve created an advanced find keyword indicator to help bucket questions into themes, however I want to build an FAQ sheet. All/any help appreciated 😅

like

Is there an easy way to create flow chats and diagrams in Excel without the Visio add-in?

like

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

like

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Anyone know of any roles or companies that hire you with basic excel skills and train you in advanced excel/analytics?

likehelpful

I made a spreadsheet to track my dating success:

The spreadsheet has an input tab with qualitative and quantitative data as well as a dashboard that automatically updates 🙂

Post Photo
likefunnyhelpfulsmart

Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Is there a way to wrap your header text within access database?

like

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
like

Does anyone know the best approach when dealing with Ad sales linear and digital in Analytics? Or any knowledge about the ad sales industry

like

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

Time to convert to xlookup

Post Photo
likefunny

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Hello Excel champs , need your help with the below screenshot. First table contains the master data with Parent and Child item details. Agenda - is it find out all the child items pertaining to make 1 unit of the corresponding parent item. In this example I took Parent Item A and exploded all the Child items and the required units to make 1 unit. Now the challenge is that I have a master data of 250,000 line items and I am trying to figure out the exploded version of all the Parent items.

Post Photo
likesmart

Help!! Time-sensitive:
Please tell me how I can achieve this:

To create concatenation of every possible combination of Type to Price for every ID.
I provided an example below with the outcome I want in the second table. Would prefer if this be down without a macro.

Post Photo
like

Does anyone use XLOOKUP over Index Match? Why /why not?

like

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

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