Hi,

I would like the output of my code to start in "A1" and either store
data laterally "B1", "C1" etc or vertically i.e. "A2", "A3" etc etc.


could someone help me with the relevant command?

- D

Sub Macro1()
For i = 1 To 100
Cells(1, i) = i
Next
End Sub

will put your incrementing numbers across and

Sub Macro1()
For i = 1 To 100
Cells(i,1) = i
Next
End Sub

will put the numbers down the first column
--
Gary''s Student


"den1s" wrote:

Hi,

I would like the output of my code to start in "A1" and either store
data laterally "B1", "C1" etc or vertically i.e. "A2", "A3" etc etc.


could someone help me with the relevant command?

- D

You can place A1 into cell A1 and use the fill handle to populate
the cells to the right and then drag downward on fill handle to fill down.
http://www.mvps.org/dmcritchie/excel/fillhandle

The quickest way though is with a macro that simply puts the cell
address into each cell and is great for testing as you can see where
a cell was move from when sorting, inserting, deleting.

See MarkCells and MarkSepAreas macros (work on selection area(s))
http://www.mvps.org/dmcritchie/excel/join.htm#markcells
http://www.mvps.org/dmcritchie/excel...m#marksepareas

You can see how I have my menus set up in
http://www.mvps.org/dmcritchie/excel/barhopper.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"den1s" wrote
I would like the output of my code to start in "A1" and either store
data laterally "B1", "C1" etc or vertically i.e. "A2", "A3" etc etc.