I need to select a row that the active cell is in. Is there a quick way to do this in code?
for example I select a1, I want to be able to select the entire row or be able to select the cell to the right a2 through cell a30
what I have tried is this and the range is giving me problems
Dim finder As String
Dim one As Range
Dim two As Range
finder = ActiveCell.Value
one = ActiveCell.Offset(0, 1)
two = ActiveCell.Offset(0, 30)
Range(one:two).Select
Bookmarks