i didnt think it could be done without macros... my work place doesnt allow them and because of this i have never bothered learning it.