You're right about, somewhere, someone has built a work-around.

As far as keeping the link, I went further than that.

I copied Ole's code and the macro into a Module.

Exported that module as a *.bas file so's I can import it anytime I need it.

I've got bazillions of *.bas files hanging around with code collected over the
years. All with descriptive names that on occasion will let me remember what's
in the bas file.

I am a batant plagiarist.


Gord

On Mon, 28 Jan 2008 16:43:00 -0800, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

And after reading yours I should always try to remember that somewhere
someone has created a work-around for the shortcomings in almost all Office
tools, and others. Another link to add to my list!

"Gord Dibben" wrote:

After reading the info Jerry posted for you, if you still need/want your sizes
in cm or mm have a look at Ole's site.

If you want to use VBA to set height and width in
mm(25.4mm/inch) for a more finite fit....................

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/...vbawssetrowcol


Gord Dibben Excel MVP

On Mon, 28 Jan 2008 07:02:29 GMT, "Vasu" <u40996@uwe wrote:

I want to adjust the Row & Column width in the form of Centimeters.

How can do this One? I could not find anywhere that option.

Plz.. Give me the solution.