Worksheet to Column Distance

C

Cosmo

Need to find the distance from left edge of worksheet to the right side of a
column. The old version of Excel used "get.cell(44) - get.cell(42). This
dosen't work in the newer versions.
 
B

Biff

Hi!

get.cell still works but you have to call it through a named formula:

Insert>Name>Define
Name: Distance
Refers to: =Get.Cell(44)-Get.Cell(42)

Usage: =Distance

Here's what help says about Get.Cell 42 and 44:

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.

Biff
 
Top