Hamilton Microlab STAR - Page 94

Microlab
®
STAR User Manual
Page 94 of 225 610766/02
The following table lists the conventions for these settings.
7RRSHQWKLVREMHFWWR
UHDG
XVHWKLVV\QWD[
Entire worksheet in a
workbook file
Specify the sheet as VKHHWQDPH, where VKHHWQDPHis
the name of the worksheet.
,PSRUWDQWYou must end the worksheet name with a
dollar sign ($).
Named range of cells
in a worksheet or
workbook file
Specify the named range as 1DPHG5DQJH, where
1DPHG5DQJH is the name you assigned to the range in
Microsoft Excel.
,PSRUWDQWYou must name the range in Microsoft Excel
before attempting to open it.
Unnamed range of
cells in a single
worksheet in a
workbook file
Specify the sheet you want to open as VKHHWQDPH and
the range as )LUVW&HOO,Q5DQJH/DVW&HOO,Q5DQJH. For
example, to access cells A1 through Z256 in a worksheet
called Sales, you would specify
Sales$A1:Z256.
7RRSHQWKLVREMHFWWR
ZULWH
XVHWKLVV\QWD[
Entire worksheet in a
workbook file
Specify the sheet as VKHHWQDPH, where VKHHWQDPHis the
name of the worksheet.
,PSRUWDQWYou must QRW end the worksheet name with a
dollar sign ($).
7RDSSHQGWRDQREMHFW
XVHWKLVV\QWD[
Append to an H[LVWLQJ
worksheet in a
workbook file
Specify the sheet as VKHHWQDPH, where VKHHWQDPHis
the name of the worksheet.
,PSRUWDQWYou must follow the worksheet name with a
dollar sign ($).
Append to a QRW\HW
H[LVWLQJ worksheet in
a workbook file
Specify the sheet as VKHHWQDPH, where VKHHWQDPHis the
name of the worksheet.
,PSRUWDQWYou must QRW follow the worksheet name with
a dollar sign ($).
127(
<RXFDQQRWVSHFLI\DYDOXHLQDUDQJHWKDWH[FHHGVWKHPD[LPXPQXPEHURIURZVFROXPQV
RUVKHHWVIRUWKHZRUNVKHHWRUZRUNERRN)RUPRUHLQIRUPDWLRQRQWKHVHYDOXHVVHH\RXU
0LFURVRIW([FHOGRFXPHQWDWLRQ
7KHIRUPDWRIDOOHQWULHVZLWKLQRQHFROXPQRIWKHH[FHOILOHPXVWEHLGHQWLFDOWH[WQXPEHU
HWF