Ok, so try?

'xlSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row = Myname

?

Or replace my code with

.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row = Myname ?

I don't really know where to place this portion?

Sorry, I'm still really new to all of this..

Mark