EdwardOcampo
07-10-2017, 05:22 AM
Good morning!
Trying to create this macro to place this function "=Left(B5, Find("~", B5) - 1)" into cell K5. I keep getting compile error. Any help will be appreciated.
Sub DailyServiceFormula()
Range("K5").Formula = "=Left(B5, Find("~", B5) - 1)"
End Sub
Trying to create this macro to place this function "=Left(B5, Find("~", B5) - 1)" into cell K5. I keep getting compile error. Any help will be appreciated.
Sub DailyServiceFormula()
Range("K5").Formula = "=Left(B5, Find("~", B5) - 1)"
End Sub