please explain line of code

[hansclark]

I'm writing a print setup macro in which I need to determine what the current top margin is. I searched VBA help and found the following snippet of code in the entry for TopMargin Property.

marginInches = ActiveSheet.PageSetup.TopMargin / _
    Application.InchesToPoints(1)

The code worked just fine and returned the correct margin value when I tested it.

My question is how/why did it work? I have never come across syntax like this. In particular I am not sure what the "/" character is for. Can anyone translate the code above into plain English?

 

[Norie]

As far as I can see the / is just the mathematical division operator.

The line of code might look a little confusing because of the use of the line extension character _.

It could be written like this.

marginInches = ActiveSheet.PageSetup.TopMargin / Application.InchesToPoints(1)

Whoops, that should be all on one line.

 

[VoG]

It is dividing

ActiveSheet.PageSetup.TopMargin

by Application.InchesToPoints(1)

in order to get the margin in inches instead of points.

 

[hansclark]

ok I think I understand now. it didn't click with me at first that this was a conversion.

just to clarify...this is like converting minutes to hours, e.g 30 minutes divided by 60 equals 0.5 hours.

thanks for the quick replies.