hey guys,
i guess my Problem should be very easy to solve, but i cant manage to do so ...
i have several words in sheet2.one word per line. every line in sheet1 should be checked and deleted if the line (colum 3 and 4) contains any of the words in sheet2. i decided to go with two for-loops,
my Problem is a error in line 7 and 9 (indicated by arrows). it seems to me that ...Cells(...).Value is not allowed for strings. i already tried .Text, checked several VBA Forums but could not find a solution. Anyone here to help me out? i would be very pleased.
Tanks in advance!Please Login or Register to view this content.
Bookmarks