Hello!
I'm hoping someone can help me out here. Please let me know if this should go in the Access forum instead, but my code is opening an excel spreadsheet and manipulating the data in excel so I hope I'm okay with posting this here.
What I'm trying to do is find a value in an excel spreadsheet (the value should always exist) and select the row that has active data in it (not the entire row). I have the find portion working, I just can't figure out how to only select the row that has active data in it. This is my code and I need to replace the "ActiveCell.EntireRow.Select" with my request.
Thank you for your help!!
I'm hoping someone can help me out here. Please let me know if this should go in the Access forum instead, but my code is opening an excel spreadsheet and manipulating the data in excel so I hope I'm okay with posting this here.
What I'm trying to do is find a value in an excel spreadsheet (the value should always exist) and select the row that has active data in it (not the entire row). I have the find portion working, I just can't figure out how to only select the row that has active data in it. This is my code and I need to replace the "ActiveCell.EntireRow.Select" with my request.
VBA Code:
Set wks = objexcelapp.ActiveSheet
With wks
.Columns("E:E").Select
Selection.Find(What:="5049923", After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.EntireRow.Select
End With
Thank you for your help!!