I want my VBA program to change the value of a cell. The cell
references are correct but the "write" or assignment step doesn't
work.

As a test, this line returns the correct cell location:

A = Worksheets("Sheet1").Cells(myLocRow(i) + Offset_Row, myLocCol(i) +
Offset_Col).Address

After the following test statement, variable A contains the current
value of the cell:

A = Worksheets("Sheet1").Cells(myLocRow(i) + Offset_Row, myLocCol(i) +
Offset_Col).Value

However, if I replace it with this step, something does not work
right:

Worksheets("Sheet1").Cells(myLocRow(i) + Offset_Row, myLocCol(i) +
Offset_Col).Value = "Test"

I added a temporary Stop statement immediately after the line above.
However, if I single-step through the above line, it does not reach
the Stop statement. Instead, excecution jumps to another step before
the assignment.

HELP! I have no idea what to do next.



--
Steven M - lid
(remove wax and invalid to reply)

A fool and his money are soon elected. -- Will Rogers