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.
 
Back
Top