range class error

Hi, I have 2 sets of code. One copies the form and the second pastes it. (the ancillary functions are sheet hide unhide etc) The problem is, at times the codes work perfectly fine. But sometimes i get the "pastespecial method of range class failed 1004" error. I have created an excel ribbon...

Hi Team, This is my first post I require an help in adding an cell into VBA invoice with formula. https://drive.google.com/file/d/0B2XVU6Hf2P1tT2xFdEZVenJuYTg/view?usp=sharing Above was an image link I want to add an two cell in K 24 & K25 & M24 & M25 and the formula is Total plus M23 14% M24...

I have an Excel 2010 VBA based application where one of the report outputs is to be annotated by the user and then sent out by email. Because the user wants to refer to open workbooks when annotating the report, I have been asked to generate the report in a new instance of Excel - it means they...

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, The code below generates the "select method of range class failed" in Excel 2007. Anyone know how to fix the code? Sub namerange() Dim r As Integer Dim rr As Range Sheet2.Range("servicestotalrow_col2").EntireRow.Insert Shift:=xlUp Set rr =...