#### parr.a.pluie

##### New Member

- Joined
- Aug 6, 2010

- Messages
- 3

I entered a formula into cells using a formula that I wrote myself using VB. It's important to note that each cell's formula is different. For example,

c1: =upper(dog)

c2: =upper(cat)

c2: =upper(horse)

The problem is that because I entered these formulas using a VB formula, I have to go through each cell and press enter in order to calculate the result (otherwise the cell is showing the formula not the result), and I have more than 33000 cells.

Does anyone know of a way to do this automatically (i.e. "press enter" in multiple cells at once)? I tried F2 and then crt+enter, but it changes every cell to the first cell's formula and as I mentioned earlier, each cell's formula is different.

Thank you in advance!