Why is my VBA excel sheet not copying over?

It's good practice to always qualify a Range object with its parent worksheet. Otherwise you're relying on a certain sheet being active when your code runs.

It's good practice to always qualify a Range object with its parent worksheet. Otherwise you're relying on a certain sheet being active when your code runs... Private Sub Adminminreport_Click() Dim I As Long, LR As Long, count As Long Dim newWS As Worksheet, partsWS As Worksheet Set newWS = Worksheets.Add() Set partsWS = Worksheets("Parts") Application. ScreenUpdating = False LR = partsWS.

Range("J" & Rows. Count). End(xlUp).

Row Range(partsWS. Cells(1, 1), partsWS. Cells(1, 13)).

Copy _ newWS. Range("A1") count = 2 For I = 2 To LR If partsWS. Range("J" & i).

Value Cells(i, 1), partsWS. Cells(i, 13)). Copy _ newWS.

Range("A" & count) count = count + 1 End If Next I Application. ScreenUpdating = True newWS. Activate Unload Me End Sub.

You are awesome! Thanks so much. – slidestyle Aug 9 at 21:56.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.