Consulting

Results 1 to 1 of 1

Thread: Solved: {Solved}calculation:multiply

  1. 05-25-2010, 11:53 PM #1
    Yjmmay34
    Yjmmay34 is offline
    VBAX Regular
    Joined
    Apr 2010
    Posts
    39
    Location

    Talking Solved: {Solved}calculation:multiply

    hi, all. I want to multiply two numbers from different cells. But there is an error said type mismatch. Does anyone know this problem??
    Thanks in advance.
         Range("D4") = totalQ1LU
     Range("E4") = totalQ1POC
     Range("G4") = totalQ1LUR
     Range("F4") = "=(" & totalQ1LUR & "/" & totalQ1LU & " )"
     Range("H4") = "= (" & totalQ1POC & "*" & Cells("4F").Value & ")" 'this row get the error
    Last edited by Yjmmay34; 05-26-2010 at 01:06 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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