Jump to content

Array of String ? For "Coppy column to array (DTI)"


vincentBsef

Recommended Posts

In fact, I can't use this block for the purpose I required.
Because I also have to count the number of previous lines that do not contain the STRING, in addition to noting the line number (from bottom to top).
But, I need it for another use, in which... this is exactly what ... I need.

So, that's cool.

Link to comment
Share on other sites

Yes. Tat's clever.  Have to admit : hadn't thought of that.

But i need to start at the end. And, i have to exclude the empty lines before.

Excluding empty row is checking for zero (in one specifique cell that canot be 0 if not empty). So, Find DTI Column won't work.

But one the first unempty row find, using that block is lighter, smarter. Must be folow by a sub, though.

I will keep it the way i wrote. 

But I already used this since I read your answer :)

And i probably should have do it before.

 

VB

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

This site uses cookies. By clicking I accept, you agree to their use.