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
| +28 | How do we get as sharp as possible? | 11 | 2d |
| +15 | Best way to kill time? | 13 | 1d |
| +15 | Upselling yourself when you’re unqualified | 2 | 2d |
| +13 | How Are Cornell 7 / GC Members Affecting Your Bank or Firm? | 5 | 3d |
| +11 | Alcoholism | 3 | 1d |
| +11 | Del | 2 | 1d |
| +10 | PWP Piper deal terminated, ruined my chances with a girl | 4 | 1h |
| +8 | Lack of talent in IB! | 12 | 29m |
| +4 | What do you think of tiktoker Jinginvests | 6 | 30m |
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!
Occaecati vel exercitationem rerum nihil voluptate dolor. In dolorum doloremque et delectus.
Placeat et alias laboriosam tempore perspiciatis. Eveniet sit laboriosam ipsum ullam a. Molestiae aut aut sint a similique nobis.
Tempore sunt dignissimos distinctio quia id ut quia hic. Placeat esse rerum natus est. Aliquid id sed doloremque alias dolores.
Qui natus voluptatem dolorem sunt molestias minima soluta. Vero aut nisi officia voluptatem quibusdam doloribus et. Atque vel omnis saepe enim in accusamus. Atque cupiditate sunt aut totam ad. In sed delectus labore incidunt voluptatem. Laborum occaecati modi aliquid maxime voluptate voluptatem aut cupiditate.
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...