Hi,
I have this following code:
I would like to alter it so it does the following:
1. Copies anything entered in cell C8 to Z8.
2. Only copies the value and not the formatting of the cell.
3. If I delete the value in C8 it also deletes the rest of the values in the range as well.
Any help would be appreciated.
Kind Regards
Dan
I have this following code:
Code:
If Not Intersect(Target, Range("C8")) Is Nothing Then
If Target.Value = 66 Then
Target.Offset(, 1) = 66
Target.Offset(, 1).AutoFill Range(Target.Offset(, 1), "Z" & Target.Row)
I would like to alter it so it does the following:
1. Copies anything entered in cell C8 to Z8.
2. Only copies the value and not the formatting of the cell.
3. If I delete the value in C8 it also deletes the rest of the values in the range as well.
Any help would be appreciated.
Kind Regards
Dan