View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Infinity[_22_] Infinity[_22_] is offline
external usenet poster
 
Posts: 1
Default How to find a particular cell using macro?


Actually i manage to find the row for "Cost" but then i cant seem t
figure out how do i go to the particular date and activate the cel
below...


Here's what i did..
For Each c In Range("A:A")
If c.Value = "Cost" Then
c.Cells(1, 1).Select
ActiveCell.EntireRow.Select
End If
Next c

Please help and thanks.:

--
Infinit
-----------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...fo&userid=3272
View this thread: http://www.excelforum.com/showthread.php?threadid=57363