Thanks CLR
sorry for a late reply,
first i try to look for the formula to count each type of error occurence
in the sheet.. i place the *array* formula on IV65536,
{=SUM(IF(ISERROR(A1:IU65535),ERROR.TYPE(A1:IU65535)=1))}
then pop-up warn!
"Excel cannot complete this task with available resources. Choose less data
or close other applications Continue without undo?"<OK,Cancel>
Maybe it will be better not to copy/paste a formula,...to count the 7 error
types..
Only by macro could give me a a Quick count..
e.g
IV1=count of *error.type 1*
IV2=count of *error.type 2*
IV3=count of *error.type 3*
IV4=count of *error.type 4*
IV5=count of *error.type 5*
IV6=count of *error.type 6*
IV7=count of *error.type 7*
i hope this make sense..
regards,
driller
--
*****
birds of the same feather flock together..
"CLR" wrote:
> Your project will require many more details to be able to give specific code,
> but maybe this will help for starters........it puts a simple formula in B1
> and copies down column B as far as there is data in column A
>
> Sub Macro1()
> 'Install formula in B1 and fill down equal to column A
> Range("B1").Select
> ActiveCell.Value = "=2*a1"
> Selection.AutoFill Destination:=Range("b1:b" & _
> Cells(Rows.Count, 1).End(xlUp).Row)
> End Sub
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
> "driller" wrote:
>
> > 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..
> >
|
Similar Threads
