Xldown with a twist - select data only

[Kevineamon]

Hi guys bit of a weird and wonderful problem here.

I have this Excel sheet, it has a table of formulas, which I have restricted to 100 rows long, by default.

There's a VBA sub that runs, when a drop down list value is changed.
It runs a script - selecting the rows one by one, expanding them to 200 rows long eg. nothing fancy.

(I created a Temp worksheet way earlier... referenced below)

Worksheets(TempWsName).Activate
ActiveCell.PasteSpecial xlPasteValues

Ok but now I want to go to, jump to the bottom row of the data.

So

ActiveCell.Select
ActiveCell.Offset(1, 0).Select
ActiveCell.End(xlDown).Select
ActiveCell.Offset(1, 0).Select

But it jumps down to the 100 cell??? WTH dude - I only copied the values... sigh...

Been at this for a while, gonna give up for tonight, but if any of you Excel angels, could come in the night and
shed some light on the subject, it would be much appreciated.

(Btw side note I'm very ashamed of my last piece of Code. Big shout out to Fluffy!
for fixing that terrible code of mine.
And for the WiseOwl videos, for teaching me
No... just no dude :D )