View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default line code modification

If myShtName = mstrSht And (arrVal(0) = "EQ" Or arrVal(0) = "BE") Then



"TUNGANA KURMA RAJU" wrote:

I have a line code
If my ShtName = mstrSht And arrVal(0) = "EQ" Then
Sheets(mstrSht) .Activate
I would like change the condition And arrVal(0) ="EQ" or "BE"
I am quite new to vba,how to modify the above line code.Thanks.