hi... the default width is 1.43 which i changed your code to as per request. i put the macro in and it worked ok on the cell selected (they opened bigger as expected), but didnt reduce down to 1.43 afterwards... on my code from contexture it stated to close column 5 back to 1.43 when the cell isnt selected anymore (well i think thats what it means) but on the code you posted it says "Columns(Target.Column)"... do i need to change this as well?????