pastespecial

Hello, Below is my code. It takes a range with a few charts in excel, copies it, and pastes it into powerpoint starting with the 2nd slide (first and last are predefined header slides). If you run this code straight through, it gives an error on "ShapeRange (unknown member) : Invalid...

Great title. Concise but long. I have a VB script to move data from a particular tab on workbook A to the same named tab on workbook B. The macro button is on A's tab being copied. The problem is that the default tab of workbook B is not where the pasting is going. The users need the workbooks...

Hi Guys, I have a rather simple piece of code; Sub ChartToImage() Dim ch As ChartObject Dim Sh As Worksheet Dim chImg As Object If MsgBox("This will remove all live charts in your document, do you want to continue?", vbOKCancel) = vbOK Then For Each Sh In...

for the life of me I cannot remember how to shorten this Sheets("MW Forecast Calculation").Range("calcday1").Copy Sheets("Next Day").Range("NextDayTempRH").PasteSpecial Paste:=xlPasteValues, Transpose:=True I have the below but I cannot remember where (if) to put transpose? Sheets("MW...

Hi there everyone. I have a worksheet with many columns of information for a record that serve several purposes. I currently copy some of the columns I need and Paste Special...Values into a new worksheet and then some different columns into another new sheet. Each workbook generated will need...

heloo people - I need to copy seeral thousand records from a windows programme into excel. Unfortunately, the program does not allow me to select all of the records at once, only one row at a time. However, I can select the top row, copy the contents with Ctrl+c, move down a row with the down...

I have a macro that copies one line (a named range) and pastes the format from this line to 1000 lines (also a neamed range). It worked no problem in Excel 2000 and 2003, but is giving a "run time error 1004 " "PasteSpecial Method of Range class failed". When I do this same process manually, I...

I'm currently setting up a macro that will input a vlookup from another workbook into a sheet, and then copy and paste just the value into another sheet in the first workbook. Sheets("CopyPaste").Select Worksheets("CopyPaste").Cells(9 + (nRow - 9), 17).Select...

Hi all, I copied a snipet of my code below. I need to simply determine how to make this process a little faster, as I have to do this for 30 subdivisions. More specifically, is there a more effiecent means to doing the pastespecial arguement, as I think this may speed things up a bit Thanks...

Does anyone see a way to paste the range I have identified as values only and not formula's. I can't seem to figure it out using the .PasteSpecial code. Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Range("A1") If Not Application.Intersect(KeyCells...