Looping through the rows

[zlatan]

Hello to all

I need a little macro that would do next:

Go through a rows from A1 to Ax ( x- the last number)

Find a text inside each of rows ( for example, i want to find any row that contain word " hello")

Delete WHOLE column with a word "hello" in row A...

Example

A B C
1 hello 1 0
2 world 1 1
3 excel 0 1

After doing macro, it should be look like:

A B C
1 world 1 1
2 excel 0 1

It would be very very helpful for my work if someone could write me a code, or give me some links. I'm not doing programming, I'm complete dummie for that.

It will save me a hundred of hours work, so I'm kindly ask you here if someone could write it for me (if it is too difficult, then forget it )

Best regards

Zlatko

[VBA Noob]

Try

Please Login or Register  to view this content.

VBA Noob

[zlatan]

Try

Please Login or Register  to view this content.

VBA Noob

It does not work.

Maybe it is because my word "hello" is in the sentence. In column A i have sentences. Some of them contain word "hello". Is it because of that?

I also find that * sign would deal with it. So i modified a code with "*hello*" but still it is not working.

And one more thing...each sentence in A column begin with > sign. Is it make any difference to excel?

[VBA Noob]

It does work just you moved the goal posts

try

Please Login or Register  to view this content.

VBA Noob