MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 289|Reply: 6

Go To column in a selected row?

[Copy link]

6

Topics

21

Posts

72

Integral

Member

Rank: 2

Integral
72
Post on 2-11-2017 14:12:57 | All posts |Read mode
I have a full row selected and I've opened the Go To dialog. The text cursor is at its left end. What do I now type in the Reference field to select the cell in (say) column H please?



Alternatively, how can I get the row number copied to theclipboard, so that I could then enter the specific cell address?
--
Terry, East Grinstead, UK
Reply

Props Report

2

Topics

804

Posts

1720

Integral

King

Rank: 6Rank: 6

Integral
1720
Post on 2-11-2017 15:47:16 | All posts



One way to achieve what you want is with a simple selection change event macro which must be placed in the SHEET module
Select a row in the attached workbook and then enter the column letter
The first line of VBA checks that an entire row has been selected.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Selection.Rows.Count  1 Or Selection.Columns.Count  ActiveSheet.Columns.Count Then Exit Sub
    col = InputBox(Enter Column Letter, GoTo, A)
    Cells(Target.Row, col).Select
End Sub








  • SelectRowGoToCell.xlsm
    (13.8 KB, 0 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    804

    Posts

    1720

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1720
    Post on 2-11-2017 17:29:41 | All posts



    One way to achieve what you want is with a simple selection change event macro which must be placed in the SHEET module
    Select a row in the attached workbook and then enter the column letter
    The first line of VBA checks that an entire row has been selected.
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        If Selection.Rows.Count  1 Or Selection.Columns.Count  ActiveSheet.Columns.Count Then Exit Sub
        col = InputBox(Enter Column Letter, GoTo, A)
        Cells(Target.Row, col).Select
    End Sub








  • SelectRowGoToCell.xlsm
    (13.8 KB, 2 views)
    Download

  • Reply Support Opposition

    Props Report

    2

    Topics

    804

    Posts

    1720

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1720
    Post on 2-11-2017 20:07:37 | All posts



    One way to achieve what you want is with a simple selection change event macro which must be placed in the SHEET module
    Select a row in the attached workbook and then enter the column letter
    The first line of VBA checks that an entire row has been selected.
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        If Selection.Rows.Count  1 Or Selection.Columns.Count  ActiveSheet.Columns.Count Then Exit Sub
        col = InputBox(Enter Column Letter, GoTo, A)
        Cells(Target.Row, col).Select
    End Sub








  • SelectRowGoToCell.xlsm
    (13.8 KB, 4 views)
    Download















  • Reply Support Opposition

    Props Report

    1

    Topics

    83

    Posts

    183

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    183
    Post on 2-11-2017 21:22:25 | All posts



    If you want, say, column-H on the same row, then just type in H3.
    However, it is not necessary to select any row, column or cell - just invoke the Go To dialog box and type in any cell reference.
    Reply Support Opposition

    Props Report

    2

    Topics

    804

    Posts

    1720

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1720
    Post on 2-11-2017 21:22:34 | All posts



    One way to achieve what you want is with a simple selection change event macro which must be placed in the SHEET module
    Select a row in the attached workbook and then enter the column letter
    The first line of VBA checks that an entire row has been selected.
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        If Selection.Rows.Count  1 Or Selection.Columns.Count  ActiveSheet.Columns.Count Then Exit Sub
        col = InputBox(Enter Column Letter, GoTo, A)
        Cells(Target.Row, col).Select
    End Sub








  • SelectRowGoToCell.xlsm
    (13.8 KB, 6 views)
    Download















  • Reply Support Opposition

    Props Report

    2

    Topics

    804

    Posts

    1720

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1720
    Post on 2-12-2017 02:42:08 | All posts



    One way to achieve what you want is with a simple selection change event macro which must be placed in the SHEET module
    Select a row in the attached workbook and then enter the column letter
    The first line of VBA checks that an entire row has been selected.
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        If Selection.Rows.Count  1 Or Selection.Columns.Count  ActiveSheet.Columns.Count Then Exit Sub
        col = InputBox(Enter Column Letter, GoTo, A)
        Cells(Target.Row, col).Select
    End Sub








  • SelectRowGoToCell.xlsm
    (13.8 KB, 8 views)
    Download















  • Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:34 , Processed in 0.177667 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!