Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format
Hello friends
Accept 2 values in two variables eg. Dt1 and dt2 and print this in the same cell, eg in 5th row 7th column one below the other €œdt1 . The variable will be replaced by value To Dt2€ CAN WE FORMAT THE DATA IN AN EXCEL SHEET/CELL LIKE FONT SIZE FONT TYPE COL. WIDTH ROWHEIGHT, ETC. SUPPOSE I WANT TO FORMAT FOR COLUMN A FROM ROW 10 TO LAST Couldwe format the data in an excel shet/cell like font size, font type, col/row width/ht etc in a macro thankyou -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200912/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format
You can specify the font size, font type, font name and row height of the
cells from A10 to the bottom of the column, but you have to resize the entire column the same (A1 to the bottom of the column). Use code something like this: With Range("A10:A" & Cells(Rows.Count).Row) ..Font.Size = 11 'use whatever number you need ..Font.Bold = True ..Font.Name = "Arial" ..RowHeight = 20 ..EntireColumn.ColumnWidth = 20 End With This will set the format of all cells in column A from row 10 to the bottom of the sheet to Bold Arial, size 11 point, in a row height of 20 and it will make the entire column "A" (including A1:A9) 20 wide. If you need something different, post more specifics; I think this is what you were asking for. If this is helpful, please click on the "Yes" below HTH "sania via OfficeKB.com" wrote: Hello friends Accept 2 values in two variables eg. Dt1 and dt2 and print this in the same cell, eg in 5th row 7th column one below the other €œdt1 . The variable will be replaced by value To Dt2€ CAN WE FORMAT THE DATA IN AN EXCEL SHEET/CELL LIKE FONT SIZE FONT TYPE COL. WIDTH ROWHEIGHT, ETC. SUPPOSE I WANT TO FORMAT FOR COLUMN A FROM ROW 10 TO LAST Couldwe format the data in an excel shet/cell like font size, font type, col/row width/ht etc in a macro thankyou -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200912/1 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
format
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |