Thank you all for the solutions provided.
Would it possible to locate the cell that has been used in the formula
and highlight that cell? Eg:
=Sum(A4,a7,a9), when we run the macro, A4,A7,A9 should get highlighted
Harry
On Apr 26, 10:28 am, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
Hi Group,
I have a weird query today, i hope i am able to present the case and a
solution is possible for it.
I need to achieve the following:
1) A macro that will search the whole sheet for those cells which consists
of formulas
2) And if a cell is found meeting criteria one, It needs to be
check this
Sub checkforformula()
Dim i As Long
Dim cell As Range
For Each cell In Cells.SpecialCells(xlCellTypeFormulas)
MsgBox cell.Address
Next cell
End Sub
Sub ab()
Dim i As Long
Dim cell As Range
'ActiveSheet.UsedRange.Select
Cells.Select
For Each cell In Selection
If
