Microsoft Excel macro - "SELECT CASE" Statements

**Ecniv** · Mar 13th, 2006, 08:57 AM

Code:

sht.cells(3,1)="=if(......)"

sht is the active sheet or worksheet you specify.

alternatively

Code:

if sht.cells(3,1)="...." then

end if

**The_Grudge** · Mar 13th, 2006, 09:08 AM

So could you do something like this then...

VB Code:

Select Case sht.cells(3,1)
    Case vbNullstring
         sht.cells(3,2) = "Cell is blank"
    
   ' and so on and so on.....
 
end Select

Thread: Microsoft Excel macro - "SELECT CASE" Statements