Create cells value based on formula in Excel VBA

I have a excel sheet like this, is there a way to get value in C8 using C6 in VBA?

!Create cells value based on formula in Excel VBA

Replay

A non VBA method:

Name the ranges by the their particulars

So, C2 would be x, C3 would be y and ...

To do this quickly:

  1. Highlight B2:C4
  2. On the Formula Tab click Create from Selection
  3. Choose Left then hit OK

Create cells value based on formula in Excel VBA

This will name the highlighted cells in Column C; x,y,z respectively.

Then your formula in C6 would be:

=x*y*1000/z

Then in C8:

=FORMULATEXT(C6)

Create cells value based on formula in Excel VBA

Category: microsoft excel Time: 2016-07-29 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.116 (s). 12 q(s)