Paste function utility

Coordinator
Dec 11, 2012 at 6:50 PM

If you check out http://xllutility.codeplex.com and include the file paste.cpp in your project it defines two macros: Ctrl-Shift-B and Ctrl-Shift-C that riff off of Ctrl-Shift-A.

Type a function built with the library into a cell, no parenthesis, hit enter. You should see a number. (It's the Excel register id of the function.) Select the cell.

C-S-B pastes the function into the spreadsheet with default values immediately below it. (Args::Arg can take an extra paramter as the default.)
C-S-C adds the names of the arguments below and one column to the left and defines named ranges for the arguments.

If you put a text string to the left of the cell containing the function, it will use that as a prefix for the named ranges.

My clients are loving this. It make creating spreadsheets much faster.

Check it out and let me know what you think!

-Keith