Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
An alternative to Target.EntireRow
Hi, I have a piece of code which copy/deletes a row of data from sheet 1 to
sheet 2 when a cell value changes to "Y" which works perfectly. The problem is I want to repeat this code on sheet 2 to delete/copy to sheet 3 in a similar way but because it uses Target.EntireRow copying from sheet 1 to sheet 2 overwrites the validation on the end cell of sheet 2 which prevents the code for copy/delete to sheet 3 from executing (hope that makes sense). Is there an alternative to Target.EntireRow which will let me stipulate the columns (i.e. A to I)? The row changes each time. Thanks Kev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EntireRow | Excel Programming | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range) | Excel Programming | |||
EntireRow.Delete | Excel Programming | |||
How find if target is object in Worksheet_Change (ByVal Target As.. ?) | Excel Programming |