On Sun, 24 May 2009 10:44:18 +0100, "Patrick Molloy"
wrote:

thats why we use parameters...

Option Explicit
Sub Demo()
Setto5 2
Setto5 3
End Sub

Ah, yess.. but I was hoping to avoid going through the routine twice.

I wonder - probably a silly question - can you use an SQL query in
Excel e.g. with a criteria Like *2* or Like *3* ?


Thanks - Kirk