Get.Cell

[lhechanova]

I used the define name and refers to =GET.CELL(6,Sheet1!$A1) , and it does
exactly what I wanted, but out of curiousity what does the 6 mean?

 

[Mike Middleton]

lhechanova -

From the Function Reference documentation for Excel 4:

GET.CELL returns information about the formatting, location, or contents of
a cell. The syntax is GET.CELL(type_num,reference). There are 53 possible
values for type_num. With type_num = 6, the function returns "Formula in
reference, as text, in either A1 or R1C1 style depending on the workspace
setting."

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Bob Greenblatt]

lhechanova -

From the Function Reference documentation for Excel 4:

GET.CELL returns information about the formatting, location, or contents of
a cell. The syntax is GET.CELL(type_num,reference). There are 53 possible
values for type_num. With type_num = 6, the function returns "Formula in
reference, as text, in either A1 or R1C1 style depending on the workspace
setting."

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

Actually, there are 66, but who's counting. The full reference is available
here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=00d31943-3ad1-4df1-
9f93-c19c7e84f01c&DisplayLang=en