Help with Variable Use

[Blauv]

I have the below variable I am using.

Dim SetFormulasLeipsic As Long    SetFormulasLeipsic = Sheets("DataB1toDUKE").Range("A" & Rows.Count).End(xlUp).Row
    
    
Range("A2:Y2").AutoFill Destination:=Range("A2:Y2" & SetFormulasLeipsic)

When I F8 through it SetFormulasLeipsic captures the correct row count. (459)
The problem comes on the AutoFill.


For some stupid reason it is adding 200 to i, and fills down to 2459......


What the heck am I missing here?

As always your help is greatly appreciated.

 

[steve the fish]

This:

Range("A2:Y2").AutoFill Destination:=Range("A2:Y2" & SetFormulasLeipsic)

says:

Range("A2:Y2").AutoFill Destination:=Range("A2:Y2459")

because the varible is just concatented to the "A2:Y2" so you just need to use "A2:Y". Miss the 2. Also qualify your ranges with the sheet name. You have for your last row variable but not when it comes to the autofill.

 

[JackDanIce]

Try:

Range("A2:Y2").Autofill Destination:=Range("A2:Y" & SetFormulasLeipsic)

Consider:

Msgbox "Hello"
Msgbox "Hello" & 2
Msgbox "Hello2" & 2

 

[Blauv]

WOW, I knew it was something stupid. Didn't even notice that. Thank's.