The first part of you suggestion was perfect. Thank you. If I need to start
at say unit 1050 up 1200 consecutively how would I go about that? A macro?
I've never used macro's. Thanks

"Don Guillett" wrote:

on row 1 copied down
="1030 33rd st #"&ROW()

or a macro
for i = 1 to 400
msgbox "1033 33rd St, #" & i
next i