+ Reply to Thread
Results 1 to 12 of 12

get name range instead of Column Range

  1. #1
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    get name range instead of Column Range

    Dear friends

    Please help me how to change the line .................>>>>>>>>>
    With WB.Sheets(WS.Name).Range("D:E")
    With WB.Sheets(WS.Name).Range(rngsearch.name)

    Thanking you in advance

    I change different methods...... like
    Dim rngsearch as range
    set rngsearch = .range(rngsearch.name)

    basically i add this name range instead of .Range("D:E") manually, but code not work properly.





    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: get name range instead of Column Range

    Try without '.value':

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: get name range instead of Column Range

    Sir I type this line but not worked.

  4. #4
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: get name range instead of Column Range

    I also tried this line.... but not worked

    Please Login or Register  to view this content.
    Last edited by internet_imran; 09-17-2019 at 01:36 AM.

  5. #5
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: get name range instead of Column Range

    Please help
    Please Login or Register  to view this content.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: get name range instead of Column Range

    Do you have a named range on every sheet called "rngsearch"

  7. #7
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: get name range instead of Column Range

    1. Please post the complete code.
    2. What do you mean by 'not work'? did the code stop with error? Which line is highlighted in yellow when the code stops?

    Set Cell = .Find(What:=Search,
    3. What is 'search'?

  8. #8
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: get name range instead of Column Range

    Thank you Fluff13 and Akuini......
    my sample book attached please see sheet and code
    Attached Files Attached Files

  9. #9
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: get name range instead of Column Range

    I have not seen your workbook yet but maybe what you need looks like this:
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: get name range instead of Column Range

    sir, thank your, but its error variable not defined

  11. #11
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: get name range instead of Column Range

    Try this
    Please Login or Register  to view this content.
    ❖ Please mark your thread is SOLVED if there has been offered a solution that works fine for you.

    ❖ If you like solutions provided by anyone, feel free to add reputation by clicking on ✶ Add Reputation bottom left of their posts.

  12. #12
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: get name range instead of Column Range

    sir Thank you very much .... you saved my time.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter range, copy range (not entire column), paste in another worksheet
    By LukeNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2018, 08:28 AM
  2. [SOLVED] SUMIF formula with dynamic column range and then expand the width of SUM range
    By gravythief in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 08:36 AM
  3. Replies: 8
    Last Post: 06-25-2015, 10:06 PM
  4. Replies: 4
    Last Post: 07-19-2013, 04:35 AM
  5. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  6. Replies: 1
    Last Post: 06-17-2006, 09:10 PM
  7. Replies: 25
    Last Post: 09-07-2005, 12:05 AM

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