Copy, Paste Special Values

**Ikeeptring** · 06-22-2009, 08:20 AM

I have formulas in 4 columns

D,E,F & G

For column 'F' I want to have a macro that willl copy and paste speacial values on click of a button. I tried recording a macro but it copy and paste special on all the columns with a formula and not just column 'F'

Does anybody know the vba code to just copy paste special values on column F:F

Thanks in advance for you help

**sweep** · 06-22-2009, 09:06 AM

Hi,

Try this:

Please Login or Register  to view this content.

Note that this only works on the populated cells starting at row 1.

To do the whole column, replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**royUK** · 06-22-2009, 09:11 AM

Try

Please Login or Register  to view this content.

Copy, Paste Special Values

LinkBack

Thread Tools

Rate This Thread

Display

Copy, Paste Special Values

Re: Copy, Paste Special Values

Re: Copy, Paste Special Values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions