Related:
- Formula to check text & return other text
- T-mobile check balance text - Guide
- Check soft - Download - Finance
- How to check pc power consumption in windows 11 - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 17, 2011 at 05:52 AM
Oct 17, 2011 at 05:52 AM
"in separate cell (on the top of the sheet)"
if this cell is C1
then try this macro
if this cell is C1
then try this macro
Sub test()
Dim cfind As Range
Set cfind = Range("C5:C850").Cells.Find(what:="error", LOOKAT:=xlWhole)
If Not cfind Is Nothing Then Range("c1") = "ERROR FOUND"
End Sub
Oct 17, 2011 at 08:35 AM
Fisrt of all, thank a lot to your reply, I appreciate it.
But It didn't worked with me, or how shall I do it, by Macro or by VBA code, I alraedy wrote on the following VBA code but didn't got any reply.
Sub test()
Dim cfind As Range
Set cfind = Range("P6:P106").Cells.Find(what:="ERROR", LOOKAT:=xlWhole)
If Not cfind Is Nothing Then Range("S1") = "ERROR FOUND"
End Sub
Thank you in advance for any assistance.
Issa