 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007column widths and row heights
based on 100% view, when u set the column width to say 12 units and the row height to, for example, 15... what is the actual dimensions in reality in mm. ie, how can i get the required number to ensure that row and colms are exactly 2 mm in width and height pat Column width and row heights defaults are not in inches or mm. The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font that fit in a cell. Row heights are measured in points or pixels. There are 72 points to an inch and "maybe" 96 pixels to the inch. For an interesting and enlightening discussion on this subject see http://snipurl.com/dzz8 If you want to use VBA to set height and width in mm.................... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP >based on 100% view, when u set the column width to say 12 units and the row >height to, for example, 15... [quoted text clipped - 4 lines] > >pat cheers have used the code pat > Column width and row heights defaults are not in inches or mm. > [quoted text clipped - 24 lines] > > > >pat You did that in 9 minutes? You can come work for me any time<g> Gord >cheers > [quoted text clipped - 30 lines] >> > >> >pat this is what i actually had to do... set the column widths and row heights for many columns,, the base code now looks like:: Sub ChangeWidthAndHeight() Dim colNo As Long Dim rowNo As Long colNo = 1 rowNo = 1 Do While colNo < 46 If colNo > 0 Or colNo < 46 Then SetColumnWidthMM colNo, 2 Else Exit Do End If If colNo > 0 Or colNo < 26 Then SetRowHeightMM colNo, 2 End If colNo = colNo + 1 Loop End Sub > You did that in 9 minutes? > [quoted text clipped - 36 lines] > >> > > >> >pat the OR is an AND > You did that in 9 minutes? > [quoted text clipped - 36 lines] > >> > > >> >pat Adelaide is probably a long way away from wehrever u reside! have a great day pat > You did that in 9 minutes? > [quoted text clipped - 36 lines] > >> > > >> >pat
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.