Forum: Visual Basic 4 / 5 / 6  Mar 5th, 2006 |
| Replies: 6 Views: 20,864 Nevermind, I got it. :surprised Thank you for all your help
Sub TESTING2()
Cells.Find(What:=Range("A1"), After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart,... |
| Forum: Visual Basic 4 / 5 / 6 Mar 5th, 2006 |
| Replies: 6 Views: 20,864 Yomet,
Public Sub Test2()
Dim c
For Each c In ActiveSheet.Range("A1:J300")
If c.Value = Range("A1") Then 'This is where your search text goes
c.Select
Exit... |
| Forum: Visual Basic 4 / 5 / 6 Mar 3rd, 2006 |
| Replies: 6 Views: 20,864 Thank you for the replies, I will try them out at work on Monday and let you know how it goes. |
| Forum: Visual Basic 4 / 5 / 6 Mar 2nd, 2006 |
| Replies: 6 Views: 20,864 Hi all,
I am a beginner at this so sorry for my ignorance.
I'm trying to make a macro that searches an Excel Spread sheet. I plan on using Data validation in cell A1 that the user selects... |
