I will use HF in my other macro called "DetectCellsFormulas" that uses conditional formatting. The formula there is =HF(A2)
Function HF(rng) As Boolean HF = rng.HasFormula End Function
|Delete texts with font color||16||30|
|Extract strings / characters from the right till the second occurrence of the underscore character||9||44|
|Auto Adjust Percent rate||5||26|
|Create Files based on Cell Values in a Range in Excel||12||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!