pastespecial range

Hi All, Can anyone tell me why I am receiving the Pastespecial of range class failed error when trying to paste a copied range of rows from one workbook to another? My code is below: Sub GetPricingData() Application.ScreenUpdating = False Dim StartDate, EndDate As Date Set MySheet =...

Hi, I have looked at a few codes and tried to put them together (crudely admittedly) but have gone wrong so hoping someone could point out my error! I have a sheet with a list of tab on in Range I2:I23 as it can vary. I want a code to check each tab on two ranges, C5:H79 & C86:H160 and copy...

Hi, I am new to the VBA and I need to copy the data from one sheet of excel and need to append the data to the another workbook of the same excel. I am trying the same but its giving me error. "vba runtime error 1004 pastespecial method of range class failed". i am trying the below mentioned...

Dear All I am new to VBA and am trying to modify a VBA code which is below. The following code perfectly copies the values form one worksheet into another. But I also want it to copy formats. Any ideas?? - Many Thanks Sub Practice_1() Dim datasource As Worksheet Set datasource =...

I am not facing an error with this code on my computer but when i try yo work on another one with same hardware and excel version (2010 proffesional), it gives this error "runtime error 1004 worksheet class pastespecial failed". I am new and i will use this code my mini-project, thank you for...

Hello, I am trying to execute the following code, but I get a runtime error 1004 (pastespecial method of range class failed). I have no idea what I am doing wrong. Any help is very much appreciated because this is stressing me out. Sub ReviewedStatusReport() 'Define variables Dim ws1 As...

Hello everyone, I using a VBA code to copy cells from various excel sheets into one master sheet. I have managed to employ VBA to copy single cells, but now I would like to copy a range of cells and transpose them into the master sheet. However, I am not able to adapt the paste special...

Hi. I'm using Excel 2010, Windows 7. For the life of me I cannot understand the logic behind pasting using vba in excel. :banghead: Anyhow, I'm getting the above error on the following macro: Sub Heading_Relining_Up() Dim rownumber As Long Dim rcount As Long rownumber = 0 rcount =...

I've been reading like posts on mrexcel.com for an hour - but still cannot fix my problem. I have what I think should be a pretty basic code to copy visible cells in one sheet, then paste values in the next sheet. I continue to get a run-time 1004 "PasteSpecial method of Range class failed"...