| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording Macro -- find max value --- create chart
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recording find Maros | New Users to Excel | |||
| Create a macro which can find a record in three books | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Can't find cell ref. when recording a macro in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
