Updated this to show that a string can be longer than 255 characters and used in a subroutine/function as a parameter that way. This shows that ... ... <看更多>

http://yourexcelvbatraining.com - Use this useful VBA Len Function to test the length of your text strings.Now watch our VBA Instr Video! ... <看更多>

Required; Variant (Long). Numeric expression indicating how many characters to return. If 0, a zero-length string ("") is returned. If greater than or equal to ... ... <看更多>