Worksheet consolidation, VBA. Stop copying column headers

Hi there,

I took another mate's sheet and applied it to my workbook to play around but ran into one problem.

The copied the range displayed is the header row of the sub worksheet. I double checked the code, but cannot seem to find where the problem is.

So if you activate the "master" worksheet, all that gets copied over is the column header.

Anyone able to assist? I must be missing something.

Option Explicit
Private Sub Worksheet_Activate()
Dim ws As Worksheet, LR As Long

Me.UsedRange.Offset(1).Clear

For Each ws In Worksheets
        LR = ws.Range("A" & Rows.Count).End(xlUp).Row
            ws.Range("A2:F" & LR).Copy
            Me.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValuesAndNumberFormats
Next ws

LR = Range("A" & Rows.Count).End(xlUp).Row
With Range("A2:F" & LR)
    .FormatConditions.Delete
    .FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=0"
    .FormatConditions(1).Borders(xlTop).Weight = xlThin
    .FormatConditions(1).Borders(xlBottom).Weight = xlThin
    .FormatConditions(1).Interior.ColorIndex = 34
End With

Columns.AutoFit
Range("A2").Select

End Sub

Thanks

In the code below:

For Each ws In Worksheets
        LR = ws.Range("A" & Rows.Count).End(xlUp).Row
            ws.Range("A2:F" & LR).Copy
            Me.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValuesAndNumberFormats
Next ws

LR = Range("A" & Rows.Count).End(xlUp).Row
With Range("A2:F" & LR)

What does the "&" mean in ws.range("A2:F" & LR)? Is it like the word AND?

Same thing with [code] With Range("A2:F" & LR)?

Also what does the following code do?

.FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=0"

thanks

if LR=1

Range("A2:F" & LR)

gives Range("A2:F1")

x = "What" & "is it?"

gives x = "What is it?"

& - concatenation operator

VB help reference extract:

& Operator

Used to force string concatenation of two expressions.

Syntax

result = expression1 & expression2

The & operator syntax has these parts:

Part Description
result Required; any String or Variant variable.
expression1 Required; any expression.
expression2 Required; any expression.

Remarks

If an expression is not a string, it is converted to a String variant. The data type of result is String if both expressions are string expressions; otherwise, result is a String variant. If both expressions are Null, result is Null. However, if only one expression is Null, that expression is treated as a zero-length string ("") when concatenated with the other expression. Any expression that is Empty is also treated as a zero-length string.