I have two sets of data on one spreadsheet side by side. I searched for a value and found it but now I need to load one of two userforms depending on what column it is in. I was originally going for an if else statment saying:

if xlcolumn(A)<value<xlcolumn(J) then
load userform1
else
load userform2
endif

if that doesnt work would a case statment work

Just catching up on some old posts and found this one unanswered. Is it OK now?

If not, please post again. Sounds like a VBA Find(xxx).Column would do the job. Find returns a range (or nothing if not found) and the .Column lets you know the column. EZ?

Fazza