Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet_change subroutine that copies selected cells to another
worksheet as they are entered. This all works fine. My problem occurs when I try and delete data from the original worksheet. If I only delete one cell it works fine and clears the cell in the second sheet. If I select a range and hit delete then it only clears the activecell off the second sheet. Can I use code to force it to do the range. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error when Target Range is block, not cell in Worksheet_Change Eve | Excel Programming | |||
Disabling worksheet_change when deleting rows . . | Excel Programming | |||
Worksheet Cell Range Name within VB Subroutine | Excel Discussion (Misc queries) | |||
Prevent error when deleting row within Worksheet_Change target ran | Excel Programming | |||
subroutine to get all of the Named range properties | Excel Programming |