How do you write VBA to a spreadsheet column 1

[Pack10]

I have a VBA routine that runs in an Access app that reads a mailbox and builds a record in a table.
I want to port the VBA to excel and load the fields into a readsheet instead of a table.
I am doing this Just to play around with Excel VBA. So, where I have the AddNew and the field Assignment,
how would I write that to a spreadsheet column?

 

[jrbarnett]

Look at the Worksheet, Cells and Range objects in the Excel VBA documentation. They are how you identify which worksheets, cells and ranges to read from or write to (whether named or not).

John