Need copy and paste macro

[alertjon]

I need a macro to copy the result of formula cells and paste only the values into another part of my spreadsheet. The copy from cells data will be posted along side existing data only when a macro action is initiated. My main problem is how to select a different column for each posting. Any help will be appreciated. jad

[VBA Noob]

Hi,

This site might help

http://www.rondebruin.nl/tips.htm

Take a look at this code Sub copy_1_Values_PasteSpecial(). Note you need to add the function for it to work

http://www.rondebruin.nl/copy1.htm#range1

VBA Noob

[alertjon]

How do I edit macros to place data into adjacent columns.