Hi All,

I have been looking around and tweak abit of my codes to suit for my case. I tried to do a macro with it and was smacked right in the face with "unable to record". Can any shi-fu teach me any workaround?

I have an excel file with alot of columns, but ultimately, i will only need to filter any ROWS that contains COLUMNS with "2012" + "Yes", and + "removal". Please note that that are 4 different types of removal, so i need to do a search column that contains word "removal". At the end, I will have to sum it all up.

One more thing i have to stress is, is is a formula array, so i have to enter "ctrl + shift + enter". AND that is when i received the popup.

here are my code (which is working, but can't work for macro as the string is more than 255, therefore showing me the popup "unable to record".

=SUM(IF(ISERROR(SEARCH("yes",'[file1.xls]frmAdministratorRecordView'!AF2:AF25550,1)),0,IF(ISERROR(SEARCH("Removal from scope -",'[file1.xls]frmAdministratorRecordView'!AD2:AD25550,1)),0,IF(ISERROR(SEARCH("2012-1.2",'[file1.xls]frmAdministratorRecordView'!L2:L25550,1)),0,1))))

Hope someone can shed some light on how i can minimize the codes so macro will accept the maximum 255 string, or to break up the codes so i can do some form of iteration, thanks.

regards,
Mel