copy method

Hello everyone. I built few months ago this macro Sub aggiornacella() a = Sheets("Lista").Range("F3").Value b = Sheets("Lista").Range("F4").Value c = "" For i = a To b ThisWorkbook.Sheets("Lista").Cells(3, 3).Value = i Application.CalculateFull c =...

Hi, Can someone please help? As the titles says, I'm trying to copy columns from one sheet to a specific cell in another sheet. It works for the first one, but when it gets to the second I get the error "Copy method of range class failed". I searched in other threads for the same error but...

Hi, I've ben pulling my hair out trying to figure out this simple code. It's supposed to copy values and formatting only from selected rows from a table in one worksheet to another worksheet, removing blanks and duplicates . I've tried multiple ways, which either work and then stop working...

Dear All, I use the below code to copy the data from .csv file to .xls file, but the format of the dates copied in .xls was in text format which gives me Type Mismatch error while subtracting two dates. Suggest what has to be done. Set t201 = xlws2.Range("A1:AZ" & sins1) Set t202 =...

Hello MrExcel users, Hope all is well. I would just like to ask on what method to use for copying an entire worksheet including the embedded objects into a new workbook. The embedded objects I am referring to are the screenshots (Clipboard to Excel using API) attached to it. It seems that the...

Dear All, I was using the below mentioned code to combine several workbooks in single worksheet. However recently i copied this code in my personal macro book (personal.xlsb) and when i run this code from macro option it gives me "Run Time Error 1004" "Copy method of Worksheet class failed"...

I am copying relatively large amounts of data from a sheet in one workbook to a sheet in another workbook using vba. To speed up the process I am using a method supposed to be faster (data is not copied via the clipboard): Set RangeWithData = WS_WithData.Range("A1:X1000") Set TargetRange =...

Hi, After spending the past seven and a half hours trying to get this to work I have admitted defeat. What I'm attempting to do is copy 27 worksheets, names set in a range "nao_sheets", paste them in to the same workbook in any position (although a new workbook would also be fine) and then...