# Performing Calculations Between Cells with VBA

#### Jambo11

##### New Member
From what I've found, I feel as though this might involve the "WorksheetFunction" command, but I'm not certain of the syntax used. This query sort of goes back to my thread about a possible 3-cell circular reference but I didn't include this in the same thread because I wasn't as to whether or not this would be involved.

Still, regardless of whether or not this would be useful in my other endeavor, I'd appreciate some guidance.

The following formulas are what I want to be able to perform through VBA, either via textbox or straight from cell-to-cell.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### wigi

##### Well-known Member
The following formulas are what I want to be able to perform through VBA, either via textbox or straight from cell-to-cell.

What formulas?

#### Jambo11

##### New Member
Dang. I could have sworn that I pasted them.

=B2/C2

=D2+F2

=E2-(B2/C2)

=E2-(B2/C2)/(B2/C2)

=C2*(E2-(B2/C2))

=I2*(C2*(E2-B2/C2)))

Last edited:

#### Jambo11

##### New Member
Also, would it be possible to input a formula that applies to every row in each of the applicable columns? Though it wouldn't be that difficult to make sets of the six formulas for X-number of rows, it would be nice to keep the amount of coding to a minimum.

Replies
7
Views
344
Replies
1
Views
107
Replies
4
Views
134
Replies
19
Views
327
Replies
2
Views
158

1,133,428
Messages
5,658,738
Members
418,467
Latest member
sc356448

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back