Coppying cells, including conditional formatting ('03 & '07)
glad to help.
regares
FSt1
"Raymond W." wrote:
Awesome. I swapped everything around and it works as expected. Thank you very
much for the fast response!
"FSt1" wrote:
hi
you code is writen to transfer values only. i would suggest you use the copy
command....
If Not Intersect(Target, Range("b4:b7")) Is Nothing Then
Worksheets("DuplicateSheet").Range("b11:b14").Copy Destination:= _
Worksheets("OriginalSheet").Range("b4:b7")
End If
regards
FSt1
|