Can't get my loop to stop!!

I have written a loop to go down a range of codes one by one, copying and pasting each active cell into another worksheet, printing that worksheet and repeating the process for the next code down in the list theoretically until the bottom cell which contains the word END, where I want my macro to stop.

Despite my variable being assigned and in VBA showing that it recognises the value to be "END" when the active cell reaches the bottom cell the macro is not stopping and carries on going into the blank cells.

Can anybody see where I've gone wrong? As far as I can see I've assigned the variables and given a condition for the loop to stop and am at a loss to why the thing keeps going once it reached the "END" cell.

Code below, any advice or thoughts greatly appreciated.

Sub PrintISINPage()

    Dim myWorkbook As Workbook
    Dim wsISINList As Worksheet
    Dim wsISINToPrint As Worksheet
    Dim ISINPrint As Range
    Dim myCommand As String

    Set myWorkbook = ActiveWorkbook
    Set wsISINList = Sheets("ISINList")
    Set wsISINToPrint = Sheets("ISINToPrint")
    Set ISINPrint = Range("ISINPrint")
    
    myCommand = ActiveCell.Value()
    
    wsISINList.Select
    Range("A1").Select
    Selection.Copy
    wsISINToPrint.Select
    ISINPrint.Select
    Selection.PasteSpecial Paste:=xlAll
    wsISINToPrint.PrintOut
    Sheets("ISINList").Select

    Do Until myCommand = "END"
        wsISINList.Select
        ActiveCell.Offset(1).Activate
        Selection.Copy
        wsISINToPrint.Select
        ISINPrint.Select
        Selection.PasteSpecial Paste:=xlAll
        wsISINToPrint.PrintOut
        wsISINList.Select
        ActiveCell.Activate
    Loop
End Sub

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!
http://www.mrexcel.com/forum/showthread.php?t=406319

Your thread is being closed for non compliance with our rules. Please PM me when you have read the forum rules RULES and made the changes to your post accordingly, i will then unlock your post so you may continue with the thread!

Post Closed