+ Reply to Thread
Results 1 to 3 of 3

Seletion of unknown range in EXCEL using macro

  1. #1
    Registered User
    Join Date
    02-28-2007
    Posts
    3

    Seletion of unknown range in EXCEL using macro

    Hi all

    I have a basic question about selecting a range.
    I would like to specify the selection of a particular range. I do not know the cells beforehand. I need to pass the value from a function. For example


    I have the following code

    Please Login or Register  to view this content.

    Suppose the value 12 is stored in Temp, I would like to get the cells from A12:B17 selected. With the above code it doesnt seem to work. Please provide me witht the correct syntax.

    Thanks in advance
    Keshav
    Last edited by VBA Noob; 03-02-2007 at 06:58 AM.

  2. #2
    Registered User
    Join Date
    11-16-2006
    Posts
    80
    hi, the following syntax is wrong

    Quote Originally Posted by keshav
    Hi all
    Range( "A & Temp : B &Temp1")
    Correct Syntax

    Please Login or Register  to view this content.
    mccreaso

  3. #3
    Registered User
    Join Date
    02-28-2007
    Posts
    3
    Thanks for the timely response.

+ 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