VBA DEVELOPER WORLD

Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading

Wednesday, December 12, 2012

Find the content in Excel with Loop

Sub WithLoop()

Dim rCell As Range

For Each rCell In Cells

If rCell.Value = "Find Me" Then
rCell.Activate
Exit For
End If

Next rCell
  End Sub
Posted by VBA DEVELOPER at 2:06 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2013 (16)
    • ►  March (4)
    • ►  February (5)
    • ►  January (7)
  • ▼  2012 (56)
    • ▼  December (6)
      • Cell Border in Excel
      • Exiting a Loop
      • Delete the value in the cell
      • Stop users from scrolling about in Excel
      • Find the content in Excel with Loop
      • Find the content in Excel without Loop
    • ►  November (5)
    • ►  October (5)
    • ►  August (5)
    • ►  July (5)
    • ►  June (5)
    • ►  May (5)
    • ►  April (5)
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)
  • ►  2011 (50)
    • ►  December (8)
    • ►  November (12)
    • ►  October (5)
    • ►  September (5)
    • ►  August (5)
    • ►  July (5)
    • ►  March (5)
    • ►  January (5)
  • ►  2010 (72)
    • ►  December (5)
    • ►  November (7)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (6)
    • ►  June (5)
    • ►  May (5)
    • ►  April (10)
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)
  • ►  2009 (10)
    • ►  December (8)
    • ►  November (2)
  • ►  2007 (2)
    • ►  November (2)

About Me

VBA DEVELOPER
View my complete profile
Simple theme. Theme images by luoman. Powered by Blogger.