View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_33_] Robert[_33_] is offline
external usenet poster
 
Posts: 26
Default Copy same cell, below next.

I am working on a simulationproject which uses in the normal excel
procedure a 13 of colums en thousands of rows.

Using Visual Basic I have now reduced the amount rows from thousands
to two rows. There is one variable which is the one it is all about.

PROBLEM: Offcourse itīs great that I use 2 rows in stead of a lot...
except, I want to write one variable away in a separate column.

For example:

cell B13 holds the value of the variable. This changes every second in
the new value. Is there some way I can copy this value to another
cell. It should go like:

time value copy to cell
1 5 A1
2 7 A2
3 10 A3
4 17 A4
5 31 A5

Any suggestions would be great.

Robert.