I'm trying to create a matrix of variable size with vba code, but can't seem to get the whole variable size part to work. I could make one that's larger than i need then search through the data until i find a row in the matrix that's full of zero's, but I'd rather just make one that's the size I need it each time. Does anyone know how to make it work? Thanks -Ricky