Hi
When you adjust a row height by dragging a tool-tip pops up with the height data, is it possible to display the row height data in a cell that updates when the height is changed.
I have used vb in access but never in excel so any suggestions would be welcome, this may seem a strange but excel autosizes cells to fit fonts, therefore I can develop a reference table for varying fonts at varying point sizes.
Many Thanks
Denman08
Unfortunately modifying the height of a cell is not a "volatile function" and as such does not invoke a calculation.
End result: you can't get the cell to update with the revised height value as and when the row is resized - a calculation would need to be invoked manually.
Last edited by DonkeyOte; 03-05-2010 at 06:59 AM. Reason: forgot to add manually to last sentence...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Many thanks for your swift & informative reply, I will resort to creating my ref table manually.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks