MsoShape add line problems

[lampela]

Hi i have a problem with excell add line method. I am generatirng barcode in excel , to do it i use VBA macro, this macro works good,and code generated are correctry readed. The problem is that i generate it in one file via add line operation and i can generate it row under row editing y1 and y2 parameter in AddLine function here is an example With myDocument.Shapes.AddLine(x1, y1, x1, y2).Line. It works great when i generate the barcods in first column,but i don't know what are x1 and y1,y2 parameters in other locations of worksheet for ex cell D12, do anyone know if it's possible to check the position in points of exact cells in excel?

[LJMetzger]

Hi lampela,

Try

Please Login or Register  to view this content.

Lewis