Cells in excel not updating

Using the dollar sign to do this, it becomes "=$A2*B

Using the dollar sign to do this, it becomes "=$A2*B$1".This can then be copied to every cell in the white area.the same relative position that A1 was to the original formula.The reason an error is returned when it is pasted into column A, is because there are no columns to the left of column A.

||

Using the dollar sign to do this, it becomes "=$A2*B$1".

This can then be copied to every cell in the white area.

the same relative position that A1 was to the original formula.

".

This can then be copied to every cell in the white area.

the same relative position that A1 was to the original formula.

EXAMPLE: Take an example where you have a column of Sales values in Pounds Sterling in column A and a formula to convert these into US Dollars in column B.

Start up Visual Basic 6 and create a new Standard EXE project. But we really can't do much with the object in this state that is visible to us.

Once you have your project, go to the Project drop down menu, and click References. Now that we are setup, we can start manipulating Excel with code. So to fix that, we will next create a workbook within the object.

You could enter the actual exchange rate into the formula but it would be more sensible to refer to a cell where the exchange rate is held, so that it can be updated whenever it is needed.

The simple formula for cell B2, would be "=A2*E1", however if you copy this down, then the formula in cell B3, would read "=A3*E2" as both references would move down a row as described above. The dollar sign allows you to fix either the row, the column or both on any cell reference, by preceding the column or row with the dollar sign.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “cells in excel not updating”