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.

Please Login or Register  to view this content.

Thanks

In the code below:

Please Login or Register  to view this content.

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

Same thing with

Please Login or Register  to view this content.

thanks

if LR=1

Please Login or Register  to view this content.

gives Range("A2:F1")

Please Login or Register  to view this content.

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.