Hi,
I have a dropdown in my worksheets that starts at cell A2 in a table. I'm doing some if then logic based on that cells data. The problem is in my initial attempt, I only used cell A2 as the range, so of course the logic only works if cell A2 has changed and doesn't work for any of the other row changes (A3, A4, etc) How can I make the if than statement work for all the row changes in column A? Since it's a table, I'd need to not include the table, I did try A:A, but got a type mismatch error. Here's what I have in code.
Thanks
I have a dropdown in my worksheets that starts at cell A2 in a table. I'm doing some if then logic based on that cells data. The problem is in my initial attempt, I only used cell A2 as the range, so of course the logic only works if cell A2 has changed and doesn't work for any of the other row changes (A3, A4, etc) How can I make the if than statement work for all the row changes in column A? Since it's a table, I'd need to not include the table, I did try A:A, but got a type mismatch error. Here's what I have in code.
Thanks
Code:
If Sheets("Santa Monica").Range("A2") = "Removed" Or Sheets("Santa Monica").Range("A2") = "Sent to DC" Or Sheets("Santa Monica").Range("A2") = "Sent to PGH" Then
