Thread: line code modification
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
  
Posts: 171
Default line code modification
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.
Reply With QuoteReply With Quote