September 14, 2010, 05:00 PM
[CLOSED] Excel Named Ranges (IN-RANGES) question
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.
TYPE=DATA, IN-RANGES='RegionalSales', $
TYPE=TITLE, STYLE=BOLD, IN-RANGES='RegionalSales', $
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, September 22, 2010 02:51 PM
September 14, 2010, 06:02 PM
Am I missing the point or wouldn't that be an extra BY or ACROSS field ?
September 14, 2010, 08:00 PM
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.
September 15, 2010, 03:35 PM
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.