Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# macro to copy special paste on ranges of data

Posted on 2014-01-09
Medium Priority
271 Views
Hi Expert's

Need. A macro to copy and Special paste all (need to retain cell background shading currently applied) into th3 following range sheet abc

range...
1.c99:af111 and ak99:bb111
2. C115:af125 and ak115:bb125
0
Question by:route217
1 Comment

LVL 28

Accepted Solution

ID: 39767656
``````Sheets("abc").Range("c99:af111").Copy
Sheets("abc").Range("C115:af125").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sheets("abc").Range("ak99:bb111").Copy
Sheets("abc").Range("ak115:bb125").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
``````
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month12 days, 15 hours left to enroll