MACRO BASED ON A NUMBER OF CHARACTERS

J

JOSEPH WEBER

I have the following code in a macro and it works fine. The format of my
original report changed, so i need the macro to do pick up data where
certain criteria are met.


If Range("Salesp") <> "" Then Call XXXXXX

I want this line to keep looping if the amount of characters is above a
certain number. in other words, this will keep going until it hits a cell
with 10 characters or more and then it will call the other macro.
 
J

Javed

If Len(Range("Salesp")) > 10 Then Call XXXXXX

Regards,
Per

"JOSEPH WEBER" <[email protected]> skrev i meddelelsen





- Show quoted text -

If the number 10 changes due to format change then you need recoding.
Better use Constant

Const ct as Integer=10

If Len(Range("Salesp")) > ct Then Call XXXXXX
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top