working on a project using VBA
I need to create a function, but i need my variables to refer to individual cells on separate spreadsheets.
say for instance i want something like
answer= cell c6* cell f3
How do i name those variables??
thanks
| +96 | People who despise the industry you work for - uncomfortable date story | 58 | 2h |
| +20 | Cardone Capital…..Crashout | 13 | 1d |
| +9 | Trapped With No Way Out | 2 | 57m |
| +6 | Things to do in Charlotte before Tame Impala | 3 | 4d |
| +6 | Who is your current crush? | 18 | 1h |
| +5 | Masters tickets lottery | 4 | 4d |
| +3 | Best Uber Eats Restaurants Toronto | 0 | 5d |
| +3 | For WSO users from NYC: What is your favorite NYC Football team? | 5 | 15h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
dim x as integer dim y as integer
x = worksheet("Sheet1").Range(B1") y = worksheet("Sheet1").Range(B2")
answer = x * y
PFWizard is right. I tend to do:
x = worksheet("Sheet1").Range("B1").Value although I'm not sure why.
You shouldn't do things you're not sure of, bro. That's not assigning any cell to x if that's what you were thinking it did. It's assigning the value in the cell to x. Big difference!
Commodi corrupti ipsum sit odit. Laboriosam quia non odit quod rerum neque voluptas. Corporis sunt sit illum omnis minus aut. Necessitatibus commodi adipisci voluptas aliquid minus repudiandae.
Ipsam et enim labore non illo iure autem. Et ut laborum perspiciatis voluptatem tempore. Voluptates dolorem mollitia non eaque deleniti. Facilis suscipit molestias architecto recusandae possimus beatae beatae. Enim ad maiores ipsa aut quia. Fugit quasi autem incidunt ut.
Qui ullam ullam sit laborum quis et eos. Ut et quod voluptas earum cupiditate. Neque qui est eum nostrum consequatur autem. Dolorem ab aut id non magnam molestiae consectetur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...