Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel Named Ranges (IN-RANGES) question
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Excel Named Ranges (IN-RANGES) question
 Login/Join
 
Silver Member
posted
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,


WebFocus 7.11/7.6
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Am I missing the point or wouldn't that be an extra BY or ACROSS field ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
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.
 
Posts: 60 | Location: Ellensburg Washington | Registered: May 22, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel Named Ranges (IN-RANGES) question

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.