MSG Box to define range of Convert to Number

  • Hello

    I am attempting to create a range defined by a value input into a message box to convert a string of "General" cells to "Number" cells.

    Currently I have this:

    Which does not seem to work. Any ideas? Ultimately I want the range input into the message box (i.e. C2:D6) to be converted to number formatting.

    Edited once, last by pike: added code tags for newbie ().

  • Maybe try this:

  • Code
    Sub Using_Variables()
    Dim valueOne As String
    valueOne = 5
    MsgBox CLng(valueOne) + CLng(valueOne)
    End Sub
  • possibly

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!