I'm new to VBA and I'm trying to write a macro that searches for a value in column A on a worksheet then selects the row that the value is in.
This is what I have so far:
mtcnumber = InputBox("Please enter MTC number")
Set Rng = Cells.Find(mtcnumber)
Rng.EntireRow.Select
The problem is it searches the entire worksheet for the 'MTC number' rather than just column A.
Could somebody help me out?
This is what I have so far:
mtcnumber = InputBox("Please enter MTC number")
Set Rng = Cells.Find(mtcnumber)
Rng.EntireRow.Select
The problem is it searches the entire worksheet for the 'MTC number' rather than just column A.
Could somebody help me out?