Compare Cell Value with Multiple Strings

[Lucky100]

Hey you all,
Hope all doing Great!

I am trying to compare the single cell value with multiple string but its not working..

if Worksheets("RawData").Cells(i,3).Value = " Person1" Then

I have tried comparing multiple stirng such as if Worksheets("RawData").Cells(i,3).Value = " Person1" or "Person2" Then

But it didn't work, any suggestions..

Thanks in advance!

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data and to post your entire code explaining in simple English what you want to happen using your Workbook examples.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jindon]

You need to change to something like

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[Lucky100]

After saving the Excel sheets which includes VBA code, then, the VBA code disappears. Is it normal? Do I have write VBA code each time?

[jindon]

If you don't save the workbook as "Macro Enabled workbook", all vba code will be cleared.

[Lucky100]

Hi jindon, oh got it. Thanks again!