I have used the IN-RANGES command to name the body or title as a whole, but i would now like to breakup the data into different named ranges (either by rows or columns) to make it easier to apply some macros.
Is there a way to do this in WebFocus or should i continue to build named ranges in VB ?This message has been edited. Last edited by: Kerry,
WebFocus 7.11/7.6
September 14, 2010, 06:02 PM
Waz
Am I missing the point or wouldn't that be an extra BY or ACROSS field ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 14, 2010, 08:00 PM
Stephen
Named ranges in excel allow you to define an area on a worksheet and reference that are in a macro. This makes reference subsets of data for charts or grouping in a macro much easier.
WebFocus 7.11/7.6
September 15, 2010, 03:35 PM
M Meagher
Could you show a little more code for this example? I cannot solve your problem, but I am interested in how you used IN-RANGES.