Is there a way in which you can use a macro to copy a row, (some cells values are numbers, some text and some are formulas) but only past the formulas.
as a simple example if i copy row 1
A1 = david
B1 = 5
C1 = 6
D1 = sum(B1,C1)
and copy it to row 2 i want the outcome to be
A2 = ""
B2 = ""
C2 = ""
D2 = sum(B2,C2)
Thanks for you help
as a simple example if i copy row 1
A1 = david
B1 = 5
C1 = 6
D1 = sum(B1,C1)
and copy it to row 2 i want the outcome to be
A2 = ""
B2 = ""
C2 = ""
D2 = sum(B2,C2)
Thanks for you help