Hi all
looking for a short expression in VBA to copy and paste values using source theme.
The shortest I found for a given cell is:
Please Login or Register to view this content.
Which is pretty cumbersome because the macro needs to do this operation for a bunch of cells on top of I2 (is there a quicker solution for that too?)
kind regards
Last edited by VanniFucci; 05-14-2013 at 02:41 PM.
Hi Vanni,
Have you tried a straight copy?
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi xladept
A straight copy is copying the formula, I need the value only
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks