any macro
 

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

any macro
 

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

any macro
 

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

any macro
 

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

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