Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to setup that mirror each other at all times. I am currently
handling "Worksheet_Change()" in my sheets, so any time one sheet gets modified, I am trying to copy the contents of one sheet to the other. The shortened code looks as follows: ' ' Sheet 1 ' Private Sub Worksheet_Change(ByVal Target As Range) changedCell = Target(1).Address(0, 0) Sheet2.Range(changedCell).Value = Sheet1.Range(changedCell).Value End Sub ' ' Sheet 2 ' 'Private Sub Worksheet_Change(ByVal Target As Range) changedCell = Target(1).Address(0, 0) Sheet1.Range(changedCell).Value = Sheet2.Range(changedCell).Value End Sub This code generally works when a user changes one cell at a time. However, (for example) if a user selects a big block of cells on Sheet1 and presses the DELETE key, that block of cells will actually delete on Sheet1, but only one (or two or so) cells will delete from Sheet2. How can I modify the subroutines above to handle cases when a block of data is highlighted in one sheet, then tell the second sheet to delete all those cells as well?? Thank you!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
synchronizing mutiple sheets to mirror the previous data | Excel Discussion (Misc queries) | |||
sheets that mirror each other | Excel Programming | |||
Mirror Wildcard? | Excel Worksheet Functions | |||
Mirror value to another cell. | Excel Programming | |||
Mirror Workbook | Excel Programming |