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!
Dignissimos ipsum quisquam dolores fugiat. Quaerat illum nulla consequuntur sit omnis in quasi. Odio impedit id voluptate harum quaerat vel.
Enim dolorum harum iure nemo delectus in velit. Nulla in autem maiores ex itaque voluptatem nisi. Placeat aperiam velit quia aliquam non. Aliquam et non voluptas est.
Sapiente adipisci laboriosam et qui recusandae. Repudiandae illum ipsa sed. Excepturi odio est quo saepe. Est voluptas eius eligendi ut nihil. Numquam voluptatibus quisquam qui reprehenderit consectetur corrupti voluptate. Delectus similique voluptas et inventore autem.
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...