format from empty cell below

G

Guest

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
 
C

Corey

have you tried the PasteSpecial code?
pasteSpecial xlPasteAll

Alt "Space bar" for options available
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Format sheet based on column contents 1
Auto format sheet 1
Dynamic Offset from an Application.Goto cell = Date or Time 10
sum currency value between empty rows 1
Copy Values From Wbk1, Outlook Them To Another PC, Paste Them IntoWbk2 1
Help in finding first empty cell in multiple ranges 2
Multiple Fxns in single sheet module 0

Top