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

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" <(E-Mail Removed)> wrote in message
news:B908D902-C142-4CBE-8879-(E-Mail Removed)...
> 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

Use the .Column property as below

Sub Mac()

Dim fld1, fld2 As Range

Set fld1 = Range("A5")
Set fld2 = Range("F5")

MsgBox fld2.Column - fld1.Column

End Sub

--
If this post helps click Yes
---------------
Jacob Skaria


"Brad" wrote:

> 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