Results 1 to 2 of 2

Thread: [RESOLVED] [Excel] VB Array Copying

Threaded View

  1. Jul 30th, 2014, 04:15 PM #2
    ThreadHelp
    ThreadHelp is offline
    Member
    Join Date
    Apr 2014
    Posts
    35

    Re: [Excel] VB Array Copying

    Excel evaluates those assignments as string. So, for example, in M27, Excel evaluates "=(M6*10)/(4*M23)" as:
    '=(M6*10)/(4*M23)
    Try pasting that manually into an Excel Cell to see what I mean.

    To fix this, you may do the following:
    Code:
    Cells(26, 13) = Evaluate("=(M6*10)/(4*M23)")
    Last edited by ThreadHelp; Jul 30th, 2014 at 04:23 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width