How to delete rows based on length of string without loop?

[Chirag R Raval]

Dear all Expert @Marc L & @Chihiro

Thnak you very much for your kind effort to
Solve this thread ,

Just 3 line code, do its job like a magic.
Thanks again this forum , Experts & users for bear
Me with my problem.& give proper solution for it .

Regards,

Chirag Raval

 

[Marc L]

In this case, it is faster for a beginner to operate manually
than thinking & creating a VBA code.
So the magic resides on Excel side, not on VBA aside …

For any common need by code, ask yourself
« What can be done on Excel side among its features ? »

As often inner features are more efficient than a VBA cells looping code,
even sometimes a VBA code is useless (for example with a pivot) …

First rule : Think Excel Before VBA !
​

 

[Chirag R Raval]

Dear Sir, @Marc L ,

Absolutely right, But, VBA stands for Automation
In repetitive task (Though some basic operatios).
& in that time , VBA look like a bllessing Angeles.

You are right, you can say it as this,

"Do VBA , but first, with use of basic inherited features of Excel "

If There are need to do , some more logical, then modify your VBA as require.

Amazing , focus on right point.

Thanks again.

Chirag Raval