Excel saving data in Range(An+1)

[Mateusz]

Hey,

I have a macro and it saves in A2 the final result
I want to data be saved in Range(An+1) after each macro use.
So if I use macro second time it should write all data in line 3 (A3)
third time- in line 4 (A4) etc.

 

[iferror]

Where you have
[A2].value=result
type
Range("A" & Rows.Count).End(xlUp).Offset(1).Value =result

 

[Mateusz]

Yep I have just done it, but thanks anyway ;D

 

[SirJB7]

Hi, Mateusz!
Maybe you want to share your solution with the community, so as people who read this would have the issue or question and the solution or answer as well.
Regards!

 

[Mateusz]

I have done it in the loop.
and each time it is beeing done data is put into the cell under the previous one

dim n as Integer
for n=2 to 100
Range("C2" & n).Value = title
next


(100--> any number may be here)

 

[JayT]

Hi Mateusz, I thought your question was how to write values into different cell in 'each macro use' (write in new cell each time you run the macro). But since you are using a for loop your solution writes the values in different cells in 'single macro use'. Next time when you run the macro it writes the values into same cells.