+ Reply to Thread
Results 1 to 7 of 7

Select range via Inputbox

  1. #1
    Registered User
    Join Date
    02-16-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    4

    Talking Select range via Inputbox

    Hi,
    I would like to select the range which i've entered in the inputbox.
    Please let me know how to do that.

    Thanks
    Last edited by nakul2617; 02-21-2013 at 07:47 AM. Reason: Corrected thread title to topic only, as per forum rules

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Select range via Inputbox

    Try this...

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    02-16-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Select range via Inputbox

    Set rMyArea = Application.InputBox("Select Range", "Range Input Required", "A1", , , , , 8)
    This is not working....I want to select the range on the worksheet which i have given in the inputbox....Please give full coding.
    Thanks

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Select range via Inputbox

    Try this...

    Please Login or Register  to view this content.

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,099

    Re: Select range via Inputbox

    Hi, Sixthsense,

    please press Cancel when running your code - RTE guaranteed.

    @nakul2617
    Could you please be a bit more precise than
    This is not working
    Code does not get started (must be invoked manually)? Range not selected? Sheet protected? RunTime Error? Which number?
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Select range via Inputbox

    @ HaHoBe,

    Good catch

    But I just wanted to give an idea to OP about how to do it and not thought about avoiding the RTE since when the OP don't have time to explain his requirement in brief

  7. #7
    Registered User
    Join Date
    02-16-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Select range via Inputbox

    Thanks....It was really helpfull....thanks again...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1