Calculate the number of Columns apart

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

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
 
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
 
Back
Top