Macro to delete formulas

**CAMTHEMAN20** · 09-09-2010, 01:35 PM

I need a macro that if the value in column L is "yes" then it needs to pastespecial only the values of the L:P columns that correspond to the cell that is marked yes.

Worksheet attached.

**CAMTHEMAN20** · 09-09-2010, 03:36 PM

Bump No Response!

**CAMTHEMAN20** · 09-09-2010, 04:46 PM

Bump No Response!

**CAMTHEMAN20** · 09-10-2010, 04:52 PM

Bump No Response!!!!Please somebody answer please...thanks

**protonLeah** · 09-10-2010, 05:23 PM

Please Login or Register  to view this content.

Remarks

The behavior of the #If...Then...#Else (compiler) directive is the same as the If...Then...Else statement, except that there is no single-line form of the #If, #Else, #ElseIf, and #End If directives; that is, no other code can appear on the same line as any of the directives. Conditional compilation is typically used to compile the same program for different platforms. It is also used to prevent debugging code from appearing in an executable file. Code excluded during conditional compilation is completely omitted from the final executable file, so it has no size or performance effect.