="1030 33rd st #"&ROW(A1050)
or

for i = 1050 to 1200 ' 1 to 400
msgbox "1033 33rd St, #" & i
next i

--
Don Guillett
SalesAid Software

"FreezingInFargo" wrote in
message ...
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