Hello,
Do You know fast method of connecting to cells to each other.
I want to search kolumns (2000rows) when find a word for example not I
want to write to another kolumn in the same row for example "Here is
not word"
Like:
________A________B__________
1 | This is a L2 | level 2
2 | This is L4 | level 4
3 | This is not | word "not"
4 | This is L5 | level 5
...........................
40| This isn't L6 | level 6
41| etc.. |
I know method of doing something like this
For Each oCell In Selection
"here is a function findind a word and pasting in B cell"
Next oCell
But how do it in a quickier way.For example using your code?
Thanks for response