jumping to wrong cell

Hello
Im working in a Workbook with multiple tabs and ultimately want to create a macro that draws from each of them and puts the info into one Tab

I'm have trouble with selecting only the data on the sheet.

When I try to jump to the last Cell with data in it using CTRL End it takes me to a cell such as AU5113 which is in the middle of nowhere on the sheet and has nothing it it.


In other workbooks this command works fine so I think I have done something to make it not work correctly.
Any assistance would be gratefully received.
Thank you

Donna
Wellington
New Zealand

Please Login or Register  to view this content.

"L" is depends on you

Thank you
What am I supposed to do with that please? I don't do coding..

Donna

CTRL HOME works fine
CTRL End take me to cells that I may have changed or deleted information from but really they should be blank and they do appear to be blank

I have another question for you please Tam That

this is the code: (I learning fast) and the steps it goes through..

Sheets("Lower Hutt").Select 1 Select the tab
Range("A9").Select 2 go to cell a9
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select 3 Ctrl/Shift/End
Application.CutCopyMode = False 4 Ctrl C
Selection.Copy 5 copy
Sheets("Full Inventory").Select 6 go to fulinventory tab
ActiveSheet.Paste 7 Paste
Range("A1025").Select Go to the next cell on the page (manually selected it puts in the cell reference)


The last step causes it to paste in specific cells every time I run it. I want to to be able to paste into the next row regardless of how many there were pasted in beforehand


Regards
Donna