CPHennessy wrote: > 1) you never mentioned what the macro is trying to do (sorry my Starbasic > is not great)
I have a range filled with different formulas (esp. VLOOKUPs and COUNTIFs) referring to different sheets of the current workbook. I would like to send just results to my supervisor, who will combine couple of sheets from different workbooks for some other purposes. So I would like to convert all these formulas into "dead data" (i.e., just values). Macro just pastes just values of the formulas in clipboard without actual formulas themselves. > 2) maybe this "feature" is already available thru the normal UI ? Yeah, but you have to fiddle with settings in Edit/Paste Special and I do it many times a day, so I would prefer just one key shortcut for this. > 3) the best list for macro questions is [email protected] OK, if I won't get better answer, I will repost there. Thanks for reply, nevertheless, Matěj -- Matej Cepl, http://www.ceplovi.cz/matej/blog/ GPG Finger: 89EF 4BC6 288A BF43 1BAB 25C3 E09F EF25 D964 84AC ..every Man has a Property in his own Person. This no Body has any Right to but himself. The Labour of his Body, and the Work of his Hands, we may say, are properly his. .... The great and chief end therefore, of Mens uniting into Commonwealths, and putting themselves under Government, is the Preservation of their Property. -- John Locke, "A Treatise Concerning Civil Government" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
