Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the same cell in different sheets in the same workbook?
Hi
I'm using the following code in a workbook. I'm investigating data by charting the data in the sheet "kurve". Sub Auto_Open() ' Sheets("Liste").Select Range("AC2").Select Sheets("Justliste").Activate Range("AC2").Select Sheets("JustRatioListe").Activate Range("AC2").Select Sheets("GNværdier").Activate Range("AC2").Select Sheets("Liste").Select End Sub Sub MellemdatacheckComplet() ' 'Kopierer pladeværdierne i liste (ukompenseret)til kurvearket Sheets("Liste").Activate ActiveCell.Offset(0, 0).Range("A1:GS1").Select Selection.Copy ActiveCell.Offset(1, 0).Range("A1").Select Sheets("Kurve").Select Range("B3").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True 'Kopierer pladeværdierne kompenseret for HDW fra JustListe Sheets("JustListe").Activate ActiveCell.Offset(0, 0).Range("A1:GS1").Select Selection.Copy ActiveCell.Offset(1, 0).Range("A1").Select Sheets("Kurve").Select Range("C3").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True 'Gennemsnitsværdierne af plademålingerne Ukompenseret Sheets("GNværdier").Activate ActiveCell.Offset(0, 0).Range("A1:CV1").Select Selection.Copy ActiveCell.Offset(1, 0).Range("A1").Select Sheets("Kurve").Select Range("D3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True 'Kopierer kompenseret for ratio og pen Sheets("JustRatioListe").Activate ActiveCell.Offset(0, 0).Range("A1:GS1").Select Selection.Copy ActiveCell.Offset(1, 0).Range("A1").Select Sheets("Kurve").Select Range("E3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True Sheets("Kurve").Select End Sub I use the macro "MellemdatacheckComplete" to investigate the data row by row from the top in the 4 sheets "Liste", JustListe", "GNværdier"and JustRatioListe".As you see in the autoopen the macro "mellemdatachec" starts in the same column and row in the 4 sheets. What I want is if I could type a rownumber in a listbox or something, so I had the same cell (cell address) selected in the 4 sheets and so afterwards run the macro "mellemdatacheckComplete? Could sombody help me with the code? Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print only select sheets in my workbook? | New Users to Excel | |||
Select All Sheets in Workbook | Excel Programming | |||
macro to select sheets/page in a workbook and print them | Excel Programming | |||
Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
Copy select sheets to another Workbook | Excel Programming |