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 December 27, 2022 - May 30, 2013 at 10:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 30, 2013 at 10:43 AM
Related:
- Create macro to search for a cell value
- Create skype account with gmail - Guide
- How to search for a word on a page - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Yahoo search history - Guide
- How to search within a youtube channel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
