Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zooming in on a row
Hi Diane,
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column < 1 Then Exit Sub ActiveCell.Resize(1, 7).Copy Sheets("Sheet2").Range("B2") Sheets("Sheet2").Select End Sub Where you will select a cell in column A and that cell and the next 6 in the row are displayed starting in B2 of sheet 2. HTH Regards, Howard "Diane" wrote in message ... How can I click on a row (or cell) and that record is seen separately on a different worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppressing Worksheet Name When Zooming Out | Excel Worksheet Functions | |||
How can I turn of zooming so that users can't change size of work. | Excel Discussion (Misc queries) | |||
Fill screen with chartobject by zooming? | Charts and Charting in Excel | |||
how do i find the root of an equation using bisection or zooming. | Excel Worksheet Functions |