Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

split : can i use split to create an array twice ?

Status
Not open for further replies.

andycape

Programmer
Joined
Aug 22, 2003
Messages
177
Location
ZA
I'm using split to break up an array and go through a loop :

ItemID = Split(ItemIDs, ",", -1, 0)
FOR m = LBound(ItemID) TO UBound(ItemID)

..... /// loop ///....


Next

I am doing another split inside the loop to create another loop and I am getting the error on theat line : "Invalid use of Null: 'Split'"

any idea what the problem could be ? both work independantly until i put one inside the other.

thanx
 
You have some empty values from the first loop
try to use Not IsNull() then split twice...

________
George, M
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top