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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...