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..