Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hot get a cell value in varable
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hot get a cell value in varable
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. "mayank" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
effective rate, debt issue costs, loan interest with varable payme | Excel Programming | |||
SQL Query Destination as an array varable | Excel Programming | |||
How can I assign a varable to equal an array? (it allready has a name) | Excel Programming | |||
Range as varable | Excel Programming |