VBA question
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
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!
Ut eaque eligendi officiis illo fugiat minima quisquam quo. Inventore qui omnis itaque incidunt illo aliquam voluptates. Adipisci dolores ut quis dolor delectus corporis. Quia molestiae aperiam et neque. Deserunt quibusdam animi et dignissimos deleniti. Nisi saepe doloribus voluptates aspernatur neque ut.
Eius est et molestiae sapiente. Hic id sit molestiae pariatur eligendi.
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...