Reply to thread

Message: [QUOTE="Mike H, post: 3764593"] Rob, A small UDF Function colwidth(rng As Range) colwidth = rng.ColumnWidth End Function Call with =colwidth(A1) or whichever column you want. If you want to convert to pixels you can have an approximation by multiplying * 7.5 or if you'd like to do the maths yourself have a look here for the correct way to convert. If you drag a column you can see the width in Pixels in paretthesis. [URL]http://groups.google.com/group/microsoft.public.office.developer.com.add_ins/browse_thread/thread/2fc33557feb72ab4/adaddc50480b8cff?lnk=raot[/URL] Me, I'd stick with an approximation!! Mike [/QUOTE]