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
Post a Comment