Hi all,

I have a table with only one column which is serial#.

Could you help me to create a macro that will concatenate "prd-" tex
with serial# value and save the results as csv file in designate
location. I am just learning VBA.
The range in serial# colum is not static, it could change every week
So the range like a1:a100 can not be assigned.

Thanks a lot and hugs to all,

S:confused

--
Message posted from http://www.ExcelForum.com