View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Alternatives to GET.CELL and VB?

Biff wrote...
....
No built-in way to get height. There is a way to get width:
=CELL("width",A1)

Kind of makes you wonder why you can get width but not height!

....

Because CELL goes way back, at least to XL2 if not all the way to XL1.
It was there for compatibility with Lotus 123 Release 2.x. Excel's CELL
hasn't changed in 19 years. 123's @CELL function, OTOH, can return row
height, text color, cell background color, whether the cell contains a
formula evaluating to a number, label or error, bold, italic,
underline, etc.

Lotus 123 Release 2.x didn't have different row heights (unless you
loaded the 3rd party Always add-in), so there was no point to having
@CELL return height. However, 123 Release 3.x included an add-in named
WYSIWYG which did change row heights, and SURPRISE! 123 Release 3
included height, text color, . . .

Why didn't Microsoft change/improve Excel's CELL function? When the
lemmings are paying you for doing nearly squat all, why work?