-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
paste values and formats
-
R
rCopy...paste values
I am trying to copy row 2 from a number of files in to a list I have used this code, which pastes "formula". can it be changed to "paste, then paste values"? Thanks in advance [Code] With Workbooks.Open(sFolder & sFile) Set rCopy = .Sheets("TF ROC").Rows("2:2")...- Rookeby7
- Thread
- Replies: 3
- Forum: Excel Questions
-
T
Simple Copy / Paste Formats & Values
I have scoured the internet, and can't find anything that I can decipher that is even close to what I need, although all of it seems to work for others. This is what I have: Sub App_Mig_Status() Workbooks("Recieving.xlsm").Worksheets("Recieving_Data").Range("A2:AS2001").Value =...- Toballou
- Thread
- Replies: 3
- Forum: Excel Questions
-
M
Retain Pivot Table Formatting
I've seen many posts about retaining the pivot table formatting when pasting values to unlink it from the source. The paste special values does not work. I've tried using the clipboard to paste and it worked one time. In the same workbook attempting to copy and paste the values and formatting...- mha112897
- Thread
- Replies: 1
- Forum: Excel Questions
-
J
VBA to Convert Selected Pages to Values Only in separate workbook
Good morning! I have this amazing bit of VBA that allows me to select pages and print in a proper order & aligns the page numbers. I want to keep this, but add an option to convert those pages to values & formats only instance of excel. Either by creating a copy of the pages into a new...- jgamse
- Thread
- Replies: 0
- Forum: Excel Questions
-
L
Copy / Paste Values & Formatting of Worksheet with Pivot Table
Hi there. I generate reports for a client each day. They have gone through many iterations, the most recent of which utilizes a PivotTable. The PivotTable exists on its own worksheet (Tab). When my report is complete, I need to copy/paste values and formatting of the entire tab to a new...- lneidorf
- Thread
- Replies: 2
- Forum: Excel Questions
-
D
Simple Paste Values and Formats Macro
In Excel 03 a simple command for pasting values and formats was included. In Exel 07 is its missing. Only a paste values button is available on the tool bar or custom list. So I tried to create a simple macro to paste formats and values using paste special after selecting my range. I...- dcortez
- Thread
- Replies: 7
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...