asked on
6 Formula in reference, as text, in either A1 or R1C1 style depending on the workspace setting.
17 Row height of cell, in points.
42 The horizontal distance, measured in points, from the left edge of the active window to the left edge of the cell.
May be a negative number if the window is scrolled beyond the cell.
44 The horizontal distance, measured in points, from the left edge of the active window to the right edge of the cell.
May be a negative number if the window is scrolled beyond the cell.
Tip Use GET.CELL(17) to determine the height of a cell and GET.CELL(44) - GET.CELL(42) to determine the width.
ASKER
Comment by: Ryan ChongSorry about that Ryan. I was thinking the whole time while writing my OP that I would be attaching the file and then forgot to do it. Here it is:
can you provide that excel sample file here as well?
ASKER
Comment by: AlanI don't remember using that shortcut {Ctrl+Alt+F9} in the past so thanks for including it. I actually googled it looking for more info and came across the following on Microsoft's Excel shortcuts page (at https://support.office.com/en-us/article/Excel-keyboard-shortcuts-and-function-keys-for-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f):
To get the Excel4 macro functions to update you have two options (at least):
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY