Results 1 to 2 of 2

Thread: excel

  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Orange Cty New York
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel

    I have a workbook with 9 different worksheets and from the main worksheet I want to be able to select a row and tab to another sheet and be one the same row.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel

    I think you are going to need to use VBA code to do this. The following code might get you started.

    <pre>Dim iRow As Integer, iCol As Integer
    iRow = Selection.Row
    iCol = Selection.Column
    Sheet2.Activate
    ActiveSheet.Cells(iRow, iCol).Select
    </pre>


    This code will activate Sheet2 and then select the same cell on that sheet as was selected on the sheet you came from. If you want to be able to select the sheet you go to, then you could use a button on a tool bar or on each sheet that would display a user form. That form would contain a combobox that you could select the sheet from, or a button for each sheet.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •