Worksheet to Column Distance
 

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.

Hi!

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

InsertNameDefine
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

"Cosmo" wrote in message
...
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.