mjcapan
New Member
- Joined
- Feb 20, 2013
- Messages
- 27
Hello all.
I am working on a macro which draws lines onto a sheet while populating cells. The lines positions are referenced to the center of the cells.
A problem I have encountered is that as data is populated into the cells the row height may be shifted to accommodate additional data. When this happens the line doesn't move which isn't an issue for that line but when I need to connect another line to it I don't have a way to reference its position.
The best possible solution I have come up with so far is to figure out how tall the cell used for the original reference needs to be relative to the data inside. My question then is does excel keep a value of necessary height for the data in a cell, perhaps as a member of the cells or range objects.
If not can I calculate that given the string length and column width.
I am working on a macro which draws lines onto a sheet while populating cells. The lines positions are referenced to the center of the cells.
A problem I have encountered is that as data is populated into the cells the row height may be shifted to accommodate additional data. When this happens the line doesn't move which isn't an issue for that line but when I need to connect another line to it I don't have a way to reference its position.
The best possible solution I have come up with so far is to figure out how tall the cell used for the original reference needs to be relative to the data inside. My question then is does excel keep a value of necessary height for the data in a cell, perhaps as a member of the cells or range objects.
If not can I calculate that given the string length and column width.