Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format from empty cell below
I'm copying data from one speadsheet to another. When I copy, the text
looses it's formatting. The WS I'm copying to is quite large so when I try to reformat the columns, it takes way too long and for some odd reason, changes the formatting of the other columns as well. Is there a way I could format the column beginning from the the bottom and looking for the first empty cell in that column and format just from the empty cell and down. I'm only copying 30 or 40 rows and the row above where I start my copy only has text, the word "Balance" in col A. All I am trying to change is the text alligned left in col B and bold and allign right in Col C. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format from empty cell below
have you tried the PasteSpecial code?
pasteSpecial xlPasteAll Alt "Space bar" for options available -- Regards Corey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custum Cell Format - display 0 (zero) when cell is empty | New Users to Excel | |||
Empty Cell Custom Format | Excel Discussion (Misc queries) | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
Finding next empty empty cell in a range of columns | Excel Programming | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) |