MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find activecell value in a range


Posted by rory on October 26, 2001 5:37 AM

Can anyone help with VBA code to find an activecell value in a range of 3 or 4 columns and select the row it is in. Only 1 instance of the value would be in the range
Thank u


Posted by Bob Umlas on October 26, 2001 6:28 AM

Columns("G:J").find(Activecell.Value).Select

Posted by rory on October 26, 2001 6:57 AM

Bob, this only selects the matching cell. i want to select the row it is in. Also know the column number from an earlier part of the code but need to link this to the range the column is in, to select the whole row of that range.
cheers rory

Posted by . on October 26, 2001 3:13 PM

Columns("G:J").find(Activecell.Value).EntireRow.Select