any macro

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

CLR,
Please advise if i need make a new thread to have a fresh look of my query...

regards,
driller