View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TheNef TheNef is offline
external usenet poster
 
Posts: 1
Default Using Filtered values as values for a chart


Hello,
I have an excel sheet that contains filters and what I want to b
able to do is create a chart using only the values that are visible a
applies to the filter . At the moment I have the macro working t
create the chart but have had to hardcode the start and end range int
the macro. The ranges will be sequential but would appreciate knowin
if this could be done wether the range was sequential or not.

Thanks in advance for any hel

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com