want to change this part of the code to look between column numbers rather then range

Please Login or Register  to view this content.

currently this code looks for textbox1 value between O1 and CZ1 but id like to do column numbers..
so id like to look between:
row = 1
mincolumn = 15

and

row = 1
maxcolumn = ws.UsedRange.Columns.Count



not sure if this is clear enough but any help would be great thank you