hot get a cell value in varable

  • Thread starter Thread starter mayank
  • Start date Start date
M

mayank

excel does not support more than seven nested if statements and i have around
20 unique values on which bases i have to fill other filed . for this i want
to use case statement in visual basic but unable to get the cell value in a
variable if any other option
 
you should first consider the data type.

i chose variant as it is most compatable


dim yourval as variant
yourval=range("a1") ---substitute a1 for the cell reference you want passed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Start Do/Loop within conditional statement 4
Improving Nested Formula Calculation Efficiency 2
Comparing a vba variable to a range of cells 5
How to get the value from a variable 1
Returning the row no of the lowest non-zero cell in a range 7
Autocomplete date for cell based on other cell values 1
if else statement 3
move a variable value in a macro to a cell 2

Back
Top