Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO BASED ON A NUMBER OF CHARACTERS
If Len(Range("Salesp")) 10 Then Call XXXXXX
Regards, Per "JOSEPH WEBER" skrev i meddelelsen ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO BASED ON A NUMBER OF CHARACTERS
On May 5, 10:36*pm, "Per Jessen" wrote:
If Len(Range("Salesp")) 10 Then Call XXXXXX Regards, Per "JOSEPH WEBER" skrev i ... 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.- Hide quoted text - - 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return value based on number of characters in cell / field | Excel Worksheet Functions | |||
move data based on number of characters in a cell | Excel Programming | |||
Deleting rows based on number of characters | Excel Discussion (Misc queries) | |||
Split field based on number of characters and space | Excel Worksheet Functions | |||
Split field based on number of characters and space | Excel Programming |