Using variables to graph a calculated range.
Posted by John F. on April 12, 2001 10:14 PM
I am trying to do something that has been elusive although I can't imagine difficult. I am trying to use VBA to graph a range that is calculated based on the first empty row (I only want the last 15 entries in the graph. I can determine the first empty cell and I know how to use variables with the Cells object for specifying a SINGLE CELL but cannot figure out how to use it to define a range of cells. Can anyone help out here? I would be greatly appreciated.