Category : Lotus and other Spreadsheets
Archive   : SRBMACRO.ZIP
Filename : WIDE.WK1

– 
/


ÿ


ÿ
q 
H
?d GERROR

GINSTRING

GLOOP



GTEMP

G\W

ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿ†ÿÿ±0
ÿÿÿÿÿÿÿÿì ÿÿÿÿ# ÿÿ
ÿÿ
gÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
%ò ** LATEST CONTROLS BY DUE DATE **|I:\GROUP\PBB\ASSIGNME.WK1|PAGE # &ò '( (
LB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
 ÿ'\wÿ
'{onerror ERROR}~ÿ
'LOOP-ÿ

'{let TEMP,TEMP+@cellpointer("width")}~%ÿ
³Ÿð
€€ 
€€Hj3ÿ
{indicate 0 }$ÿ
'Press enter for next column, (ÿ
'control-break to stop WIDTH ===>ÿ
'{?}{esc}~{right}/xgLOOP~ ÿ'ERRORÿ
'{indicate}/reTEMP~/xqÿ'INSTRINGÿ
'{indicate }ÿ'TEMPBÿ

'How wide is your spread sheet? How wide should you set theDÿ
'margins so the spread sheet will print correctly? This macroDÿ
'will tell you. Simply place the cursor in the left column ofDÿ

'your print range, invoke the macro, and press enter until youEÿ
'are in the right column. The total width will be displayed inCÿ
'the indicator in the upper right corner of the screen. When6ÿ
'finished press control break to stop the macro.?ÿ
'To invoke the macro hold down the macro key (Alt on most(ÿ
'computers) and press the "w" key.Fÿ
'If you combined this with another spreadsheet you will have to Dÿ
'name the column to the right of the \w. To do this place theAÿ
'cursor on the \w and press slash (/), Range (R), Name (N),Gÿ
'Lables (L), Right (R), Page Down and Enter. This will name the Aÿ
'column to the right of the \w with the names in the columnÿ
'with the \w.