View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Consolidate On Steroids???

On 2/18/2018 5:56 PM, GS wrote:
...

-this will be a back&forth situation and so you may want to use email for
direct exchange rather than posting numerous download links here.

...

I'm working on cleaning up a version this AM...I've got until noon budget
meeting -- if you visit before then, send me an e-mail at the result of

=CHAR({100,112,98,111,122,97,114,116,104,64,115,11 9,107,111,46,110,101,116})

if CHAR would operate on the array instead of just the first element in the
array (I'm sure there's a way to do this in Excel it would just be

CHAR([100 112 98 111 122 97 114 116 104 64 115 119 107 111 46 110 101 116])

in Matlab :)


Square brackets in VBA denotes a range. The following are equivalent:

Range("A1:E1")
[A1:E1]

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion