 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2008Get.Cell
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? 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 >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? On 7/25/08 2:21 AM, in article #2zPr6h7IHA.5024@TK2MSFTNGP03.phx.gbl, "Mike Middleton" <mike@mikemiddleton.com> wrote: > lhechanova - > [quoted text clipped - 12 lines] >> 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? 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  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.