Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format last 20 rows
I've got a very long spreadsheet that I copy information to every day. I
would like to format the text that is copied over via a range command to be formatted like the existing text in the document which would mean I need to change the following charactristics .HorizontalAlignment = xlLeft Selection.Font.ColorIndex = 0 Selection.Font.Bold = False Is there a way, since this speadsheet has over 50,000 rows to just designate the last 30 cells in col B have the above format? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format new rows. | Excel Discussion (Misc queries) | |||
Format Rows | Excel Discussion (Misc queries) | |||
format new rows | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Format rows | Excel Discussion (Misc queries) |