If you want to respond to prompts everytime you run it after the firs
time,
you like repetitious code, and you don't mind renaming the curren
workbook
to a CSV file (and losing any changes not saved before running th
macro),
then I guess you have a solution.

all i did was add a few of lines

Which 3 people took time to provided you with.

-------------------------------------------------------------------------------------------------
Tom,

You are indeed a 1st class prat, Im not sure what the bad attitude i
for in your replys to me but im guessing your someone who dosnt get ou
much and has no friends or life and therefore no real interaction wit
people in everyday life.

In all of my posts i made it clear how thankful i was with any hel
given, i made it clear as well i havnt got a clue about code so i wa
muddling thro it, i managed to get something that works for me which i
all i wanted, it dosnt matter to me how much the code is repeated etc a
long as it works, the only time it prompts me for anything is when
want it to , and i dont want to save the work which ive done s
everything works excellent for what i want.

You also take out a line "all i did was add 3 lines" which you took ou
of context and made it look like i was being ignorant or arrogant ,
guess thats more a reflection of your personality than mine, all i wa
doing in fact was saying i had solved my problem and showing how i ha
done it also by saying thanks at and of post for all help to those wh
helped me in the right direction.

Once again thanks to all those helped including Tom, but especially t
those on here who help as much as they can without leaving sarcasti
messages, thanks

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=27150