Results 1 to 13 of 13

Thread: A really, really strange Excel problem

Threaded View

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    A really, really strange Excel problem

    Create this sub, put a breakpoint on the End Sub line and execute it
    Code:
    Sub test()
    Dim strCol As String
    strCol = "AJ"
    'MsgBox strCol
    End Sub
    In my Excel if I check at the breakpoint what strCol is, it shows up as blank! However if I uncomment the MsgBox line the Msgbox shows AJ.

    Note that if I change strCol to "XX" or any other value (as far as I know), strCol becomes XX with or without the MsgBox.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width