Create macro to search for a cell value
Closed
jesanicholls
Posts
1
Registration date
Tuesday May 28, 2013
Status
Member
Last seen
May 28, 2013
-
May 28, 2013 at 01:53 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 30, 2013 at 10:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 30, 2013 at 10:43 AM
Related:
- Create macro to search for a cell value
- Www.google.com search video - Download - Video playback
- Create skype account with gmail - Guide
- Create a yahoo email account for free - Guide
- Run macro when cell value changes - Guide
- Vim search for word - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
May 30, 2013 at 10:43 AM
May 30, 2013 at 10:43 AM
Hi Jesanicholls,
First we need to specify the search value.
Start code with:
Dim sValue As String
sValue = Range("J1").Value
Then look for the Cells.Find part of the code and change the text found after What:= into sValue.
If you need further assistance then post your code along with your question.
Best regards,
Trowa
First we need to specify the search value.
Start code with:
Dim sValue As String
sValue = Range("J1").Value
Then look for the Cells.Find part of the code and change the text found after What:= into sValue.
If you need further assistance then post your code along with your question.
Best regards,
Trowa