VBA copy value until reached a certain value

Closed
Report
Posts
1
Registration date
Tuesday February 17, 2015
Status
Member
Last seen
February 17, 2015
-
Hello,

I would like the following thing to do:

I have one sheet in which I have a value from and a value to. For example from B4= 104 (from)
B5= 160 (to)

In another sheet I would like to have in cell A1 the value 104 and then in A2 105 and so on until reached 160.

Ofcourse the values in B4 en B5 change so the number of times it has to be copied also changes.

I am a real newbie in VBA so maybe this is a stupid question.

Please help me.