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.