Hi Ann,
For the issue of not finding words in hidden cells, change the details in the
.find statement from 'LookIn:=xlValues' to 'LookIn:=xlFormulas'.
I don't know why this should be so, but for some reason 'LookIn:=xlValues'
won't see hidden cells.
This may even solve your other issue of not se
I have done a new code for you, check this out
Sub find_text()
Dim ws As Worksheet
Dim startrow As Integer
Dim startcol As Integer
Dim endrow As Integer
Dim endcol As Integer
Dim find_text As String
Dim pasterow As Integer
Dim cell_address As String
pasterow = 1
find_text = InputBox("Please enter
