Macro/VB Help Defining a Range

Associate
Joined
18 Oct 2002
Posts
1,202
Location
Bristol
nxmasterpam1 = nextmastertable.Cells(1, 1).Value
nxmasterpam2 = nextmastertable.Cells(1, masteritemcolseparation).Value

If pam1 = nxmasterpam1 And pam2 = nxmasterpam2 Then

The above code looks for a specific value in the relevent cells. If I want the pam1 to fall within a specified range, how do I code that?
 
Back
Top Bottom