selecting cells one to the right of highlighted row

[Macro_]

Hi all, I currently have this code to select data in a row. I need the macro to always select the cell one to the right of the highlighted selection (ie. the next blank cell in the row) How would I do this? Appreciate any help ,thanks!

    Range("F21").Select
    Range(Selection, Selection.End(xlToRight)).Select

[:) Sixthsense :)]

May be try something like this...

Selection.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Offset(, 1).Select

[Macro_]

Thank you for your reply Sixthsense I have this error coming up when I try that - 'run-time error '91': Object variable or with block variable not set'

[Macro_]

It is most likely my fault for changing my method of selection, I now have this code however I still need to make it so that rows 21-23 are selected without the column reference

    Selection.End(xlToRight).Select
     Range("U21:U23").Select
     Selection.Copy
     Windows("data.xlsx").Activate
     Range("I23:I25").Select
     Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
         :=False, Transpose:=False
 End Sub

[jolivanes]

"always select the cell one to the right of the highlighted selection"

ActiveCell.Offset(, 1).Select

"the next blank cell in the row"

Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(, 1).Select

"rows 21-23 are selected without the column reference"

Rows("21:23").Select

This is not what you mean I am sure but it is IMHO what you asked for.

A detailed explanation is in my opinion better than a code that does not do what you want.

Note: Selecting is a waste and should not be used if not required.