• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Charting XML Data > Processing the Data for Use in Charts

Processing the Data for Use in Charts

The grades data is now in the workbook, on the Data worksheet. One of the requirements is to provide the range of dates in the grades data. To accomplish this, the SpecialCells method is used to populate the end_row variable with the last significant data row:

Selection.SpecialCells(xlLastCell).Select
end_row = ActiveCell.Row - 1


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint