vba - Excel IF - THEN with 2 actions -


i have macro checks value of cell in column j. based on value need set cells in column k , l want use following code:

for each cell in telrange   cell     if left(.value, 3) = 201       cell.offset(0, 1).value = "mobile" , cell.offset(0, 2).value = left(value, 5)     end if   end next cell 

this not work.

someone have idea how this?

from question sound works 1 action not 2, right? try spliting 2 lines (and used logical operations, if , b)

for each cell in telrange   cell     if left(value, 3) = 201       cell.offset(0, 1).value = "mobile"       cell.offset(0, 2).value = left(value, 5)     end if   end next cell 

if doesn't work, please what's happening. error message? doesn't update?


Comments