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.
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.
Last edited by CAMTHEMAN20; 09-10-2010 at 06:44 PM.
Bump No Response!
Bump No Response!
Bump No Response!!!!Please somebody answer please...thanks
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.
Last edited by protonLeah; 09-10-2010 at 05:28 PM.
Ben Van Johnson
It works very well!!!!
Thank you very much protonLeah...your time and effort is greatly appreciate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks