| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select corresponding row on another worksheet
Hello
I'm trying to write some code that will select the corresponding row on another worksheet to the current row on the existing worksheet, and I'm failing miserably. Can someone help me please. Thankyou Aehan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select corresponding row on another worksheet
In a standard module enter:
Sub tester() Application.ScreenUpdating = False MyRow = ActiveCell.Row Sheets("Sheet1").Activate Rows(MyRow).Select Application.ScreenUpdating = True End Sub Create a forms button to run tester "aehan" wrote: Hello I'm trying to write some code that will select the corresponding row on another worksheet to the current row on the existing worksheet, and I'm failing miserably. Can someone help me please. Thankyou Aehan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select corresponding row on another worksheet
Dim rng as Range set rng = ActiveCell Application.Goto worksheets("Sheet2").rows(rng.row), true -- Regards, Tom Ogilvy "aehan" wrote: Hello I'm trying to write some code that will select the corresponding row on another worksheet to the current row on the existing worksheet, and I'm failing miserably. Can someone help me please. Thankyou Aehan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select corresponding row on another worksheet
Thankyou, both Tom and Jim, both solutions work and you have really helped me.
Aehan "Tom Ogilvy" wrote: Dim rng as Range set rng = ActiveCell Application.Goto worksheets("Sheet2").rows(rng.row), true -- Regards, Tom Ogilvy "aehan" wrote: Hello I'm trying to write some code that will select the corresponding row on another worksheet to the current row on the existing worksheet, and I'm failing miserably. Can someone help me please. Thankyou Aehan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a worksheet | Excel Worksheet Functions | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| Select a cel on a worksheet | Excel Programming | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Hybrid Mode
