activesheet.paste issue

Help. I recorded the macro and am trying to clean it up but keep running into a problem. Here is my very clumsy code. Application.DisplayAlerts = False Application.ScreenUpdating = False Sheets("Credit Template").Visible = True Sheets("Credit Template").Select...

The following code is failing randomly, when I step throught it(f8) the code executes. Any thoughts on why this might be failing? Dim S as Integer Dim E as Integer Dim WBT as WorkBook Dim WS16C as WorkSheet WS16C.Range("H" & S & ":H" & E).Copy With WBT.Sheets("CPC Analysis").Range("C7")...

Hello everyone! I am trying to create a button which cuts cells Bx to Fx if the cell Fx contains the word "outlier" and paste it to a different part of excel sheet. My code seems to work up to the "Cut" part but stops at the paste. It has an error on "ActiveSheet.Paste" part of the code. Please...

Hello all, I just got introduced to VBA and am trying my first steps in it. I have data in 3 consecutive rows (let's say A1:E3) and every 3 rows of data, I want to move that "block" --> two cells to the right. So basically, I have: A1 B1 C1 D1 E1 A2 B2 C2 D2 E2 A3 B3 C3 D3 E3 That want to...

I am running code on thousands of lines of data with a loop. The code runs smoothly for a long time then will debug on the public function below. It goes through this paste function many times and just quits working randomly. I am coping data from a Reflections session then finding the cell in...