if statemenst

Hi team, I would like to add CODE_1 in front of CODE_2 but not sure how to do it. It has to be merged into one macro, under the Private Sub Worksheet_Change(ByVal Target As Range) 'CODE_1 If ThisWorkbook.Name = "NAME.xlsm" Then run CODE_2 Else Exit Sub End If 'CODE_2 Private Sub...

I am working on contacts sheet which I need to get the name from email. Multiple cases I have to faced and with the help of below post link, I formed the sheet below. Extract name and company from email address Case 1: The mail id may contain separators like dot, dash and under-score Case 2...

Hello, i wanted to see if there is a better way for an doing multiple if or statements then just listing if xxx=??? or xxx=??? I have an if statement like so is there a way to get this done better, or maybe have it listed on a tab on excel and make it a reference? just so its not a large if or...

Hello, So I am trying to write a script that if column d has a value in it and column g has false then nothing happens. However if column d has a value and column g does not equal false, then it should turn red. Here are the two scripts I have written: Public Sub Test1() Dim lastrow As...

Trying to find if this is possible. I have a list of names which I am trying to do If Statements on. I need the if statement to return a value if a specific cell equals one of the names on the list. The list contains 75 people so would need multiple if statements. Instead of doing an if...