Re: Passing information from VBA variable to Excel range

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 09:52:36 -0400

That is it

Range("C1:D100").Value = variant_matrix 

-- 
Regards,
Tom Ogilvy
"Doug R" <dougrosenbaum@hotmail.com> wrote in message
news:47021b30.0404300543.16ac3db6@posting.google.com...
> I am new to this - sorry for the basic question.
> First I grab a range of data from excel and put it in a variant by:
> variant_matrix = Range("A1:B100").Value
>
> then do a whole bunch of manipulation in vba,
> now I want to pass the variable back to excel in the range("C1:D100")
> is there a way to do this efficiently? The only way I have found that
works is
> to use a loop and do it cell by cell which is very time consuming.
> Is there an equivalent to:
>
> Range("C1:D100").Value = variant_matrix
>
>
> Thank you,

Relevant Pages

  • Re: ICON Arrows UP or DOWN
    ... Microsoft MVP - Excel ... "DOUG" wrote in message ... your link instantly with the standard warning that internet use is logged and ... but the icon would not center in the cell. ...
    (microsoft.public.excel.misc)
  • Re: Mail merge directory using excel file
    ... Doug, I tried that and the last cell on the page doesn't have enough room, so ... Doug Robbins - Word MVP ... The name that comes after Jane Doe will be one line higher than the ... Excel ...
    (microsoft.public.word.mailmerge.fields)
  • merge word with excel
    ... I have a basic question. ... Can you merge a specific cell from a ... spreadsheet in excel into word? ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ICON Arrows UP or DOWN
    ... Microsoft MVP - Excel ... "DOUG" wrote in message ... but the icon would not center in the cell. ...
    (microsoft.public.excel.misc)
  • RE: Excel formula
    ... if the number is in cell A1 ... "Doug" wrote: ... deduct that percentage from the number to get the net total. ... How do I create this formula in Excel?? ...
    (microsoft.public.excel.misc)