Help with pieces of a code that copy things into a new sheet

[ammartino44]

How does the "Move after" work? The "1" after the "count" is doing what? What is "mod"? What is "If Not"? Thanks

Please Login or Register  to view this content.

[judgeh59]

the .add.move after:= counts how many worksheets there are and moves the worksheet there.

if you are talking about the intLastRow = wks.Cells(Rows.count, 1) <---- the 1 is column 1

MOD returns the remainder after a number is divided by a divisor

the If Not reverses/negates/switches the thing after it....so, IsEmpty(wks.Cells(intRow, 1)) if the ISEMPTY() returns a false then the NOT changes it to a TRUE....

HTH