dankot123
01-15-2017, 01:25 PM
object_loc = Application.WorksheetFunction.Match(object, data.range("B1: B100"), 0)
when i use a value for object that isn't in the list the entire function doesn't run, is there a way to say if there is no value like object in the list to skip this step
maybe
if object_loc (does not exist) then
"Do this"
else
" use object_loc"
end if
or is there another way
when i use a value for object that isn't in the list the entire function doesn't run, is there a way to say if there is no value like object in the list to skip this step
maybe
if object_loc (does not exist) then
"Do this"
else
" use object_loc"
end if
or is there another way