Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello again,
i read sometime ago about a macro about a macro that can embed formula in a worksheet... (e.g) I have one workbook... it may have one or more worksheets... I need to run a macro that can embed the required formulas...... in the last column of the spreadsheet from Row 1 to Row 7, corresponding to the *count* of each error.type RESULTS that exist in the CURRENT SHEET only..... Hence, after i run the simple macro, i have a sheet report on the last column, showing the count of each type of error... the last row and the last column, shall not be included in the *count-of*.. Note: the sheet may contain merged cells. thanks and regards, driller -- ***** birds of the same feather flock together.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |