I am getting a type mismatch error.
When I mouse over the cell reference, value for the cell is "" while the value for changeorder is a number.
Range("U23") = Range("U23") + ChangeOrder(X, 12)
I am getting a type mismatch error.
When I mouse over the cell reference, value for the cell is "" while the value for changeorder is a number.
Range("U23") = Range("U23") + ChangeOrder(X, 12)
Last edited by dgkindy; 04-23-2009 at 09:47 PM. Reason: Solved
Please edit your post to add code tags.
If U23 has a null string (as opposed to being blank), then you should do this:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks