View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JOSEPH WEBER JOSEPH WEBER is offline
external usenet poster
 
Posts: 33
Default MACRO BASED ON A NUMBER OF CHARACTERS

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.