It may be a version issue, I use variables in dim statements
alternately what you could do is just count the number in your vender sheet
and enter that number in the macro dim statement
in this case don't bother with the count statement.

"Rich K." wrote:

BJ - getting compile error: on Dim ven(n, 2). The n is highlighted with the
message: constant expression required