Copy and Paste Values ..... then Reverse !

J

jagstirling

Help please !

I am trying to write a macro that will copy and paste values in
highlighted range if the value in another cell is "Y" and to leave th
formula in the cell if that value is blank.

As an example, a simple range of cells headed open, add, take, close
freeze in range A1:E5 (as per below);

4708

I am looking for a macro that would (when run) allow rows 3 and 4 to b
copied and pasted as values, so that changes to row 2 do not have
knock on effect to rows 3 and 4.

This macro would need to be be reversed, ie. when the Y in row 3 i
removed then the formulae are replaced.

This is a simple example and the formaule are quite complex in realti
so reversing the macro as opposed to re-inserting the formulae into th
copied and pasted as values cells would be favourable (as I am not a
expert in writing VB and to start having to code complex formulae migh
be a little too much)!

If you can help please do !

Many thanks

+-------------------------------------------------------------------
|Filename: a.txt
|Download: http://www.excelforum.com/attachment.php?postid=4708
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Having difficulty copying and pasting on VBA 3
Select and copy only cells with values, open an app, paste into 2
Cell values to an array, then array transpose to another workbook 8
Skip copying empty column where remaining rows are filled 2
Copy, paste to active workbook? 1
Find number in Row 1, Copy Paste Values in Rows below 5
Macro will copy formula instead of value 6

Top