Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
On an Excel Worksheet I want to view column headings as I scroll . | Excel Discussion (Misc queries) | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Seach Column and return multiple dates to another worksheet? | Excel Worksheet Functions |