Coordinates for Drawing Lines in Excel Using VBA

[adrian.groves]

Hi,

I have been trying to set a grid of 50 cells x 50 cells and use the Shapes.Addline method to draw lines on it using coordinates that relate to that grid.

I think I understand the coding but am not clear how Excel decides where to draw the line on my screen. For example if I use ....Shapes.AddLine(10, 10, 20, 20) it will draw a line from 10,10 to 20,20 but how does it know where 10,10 or 20,20 is?

I would have thought it relates to the column width or row height but cannot work out the relationship.

Thanks in anticipation

 

[mrshl9898]

I believe the measurement is in "Points".

48 points = 64 pixels by the looks of it.