Recent content by suryu

Hi , Anybody help to retrieve pivot data table to mail body in outlook -> I want to create pivot table from data and covert pivot range table data to mail body and delete blank column from pivot table

How to open outlook with subject line "Report-02/16" and read table data in body of mail or export table in excel using VBA

ok thanks

okay fine is there any possibility to add one more criteria in my given code

yes its different, i dont want to hide i just want to filter with given conditions

@arnelgp, please help me on this. Thank you

can anybody help me on this : I Want to filter column A with name like , "ESAF", "E S A F" OR any name like "FBI *" i am trying to do below code: strName="FBI" Activesheet.Range("$A$1:$CT" & lastRow).Autofilter Field:=1, Criteria1:="=*" & strName & "*", Operator:=xlOr, Criteria2:="ESAF" i...

using VBA only

yes that is the issue for two criteria it is working fine

Can anybody suggest what to do?

Its done thank you

I want to filter the column value which should not contain string starting with "Bank", "HDFC", "SBI" trying to do below code but not getting required results Activesheet.Range("$A$1:$CT & lastRow").AutoFilter Field:=13, Criteria1:=Array("<>Bank*", "<>HDFC*","<>SBI*")

Ok i will try that ...thank you

Getting update , not update pop up despite of keeping "Application.screemupdating= False" in the beginning of code. Is there something else i need to keep?

No is there any other approach for that ?