I am trying to record a macro that finds the maximum value in a gri
file.

Basically, I have this huge worksheet, with lots and lots of column
and rows (maybe 1000x100). I have more than a thousand worksheets, so
need to create a macro!

- I need to find the max value in the worksheet (cell location change
per worksheet, obviously).

- I need to take the row that the max value cell is located.
- Take this row and set it as the y-values for a chart, and se
1,2,3...n for x-values for the chart

- Repeat steps above to find the column containing the same max valu
cell... create y-values with this and 1,2,3...n for x-values.

How do I do this??

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