I'm not sure why your answer is not either 4 or 6 as opposed to 5, but if
that is the answer you want...

Difference = Range(Field1, Field2).Columns.Count - 1

--
Rick (MVP - Excel)


"Brad" wrote in message
...
Thanks for taking the time to read my question.

I have a user form that the user enters cell range info by clicking on the
control that lets you click on a cell and it puts the range in the field
(lot
of native excel dialog boxes are like this when making charts)

I have 2 fields that have range info in them, and I'd like to know how I
can
calculate the number of columns between them using the info from the form.

For example Field1 = $A$5, Field2 = $F$5. So the difference would be 5.

I hope this makes sense.

Thanks again,
Brad