Avatar of DemonForce
DemonForce asked on

Copy range and paste only formats

Hi,

I use this...

        activesheet.Range("D180:I219").Value = activesheet.Range("master").Value

to cut and paste values without using clipboard, is there a way to use very similiar but just copy and paste the format of the cells and none of its data?
Microsoft Excel

Avatar of undefined
Last Comment
gowflow

8/22/2022 - Mon
Saqib Husain

Not similar but the

copy
Pastespecial

combination can do this.
ASKER
DemonForce

Yeah used that, but is there a faster way?
Saqib Husain

What formatting are you trying to copy over?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
DemonForce

Borders...

Basically the sheet has a nice layout, but copy and paste or ctrl-c etc in the wrong place messes the sheet up, so I use a design sheet to recopy the layout back to the original so any mesed up stuff gets put straight back.
gowflow

ActiveSheet.Range("master").Copy
ActiveSheet.Range("D180").PasteSpecial Paste:=xlPasteFormats
will paste the formats only.

ActiveSheet.Range("D180").PasteSpecial Paste:=xlPasteFormulasAndNumberFormats
Will paste formulas and Format Numbers

ActiveSheet.Range("D180").PasteSpecial Paste:=xlPasteValuesAndNumberFormats
Will paste Values and Number Formats.

gowflow
ASKER
DemonForce

Yeah, I tried those before but even with switch off screnupdating and events I get flicker
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
gowflow

your comment is to my post ?
gowflow
ASKER
DemonForce

gowflow, yes I have tried that and it works, but not fast enough
Saqib Husain

Actually borders are a slow process and I do not see any way out of it.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
gowflow

can you post  sample of what you want to copy, maybe you have something that intervene with this.
gowflow
Norie

Why not copy the design sheet?
ASKER CERTIFIED SOLUTION
gowflow

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question