move a variable value in a macro to a cell
 

Within a macro I am using several variables as counters. At the end of the
the session I need to move the values of the variables into the spread sheet
before saving. I used the value statement to bring the cel values in the
variables but can not go the other direction.

move a variable value in a macro to a cell
 

If x is your variable...

sheet1.cells(1,"A") = x