+ Reply to Thread
Results 1 to 8 of 8

Select Range formula without Error

  1. 03-14-2024, 07:30 AM #1
    Yaghoub61
    Yaghoub61 is offline
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    188

    Select Range formula without Error

    Hi all,

    I have a Range with formula : G2:H7

    Range G2:H5 has data
    Range G6:H7 has erorr

    I want to select Range G2:H5 wiht vba code

    Explanation that the number of rows can be variable

    Thanks
    Attached Images Attached Images
    Attached Files Attached Files
    Notice:
    my main language is not English
    Reply With QuoteRegister To Reply
  2. 03-14-2024, 07:35 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,337

    Re: Selecte Range formula without Errorr 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 03-14-2024, 08:00 AM #3
    Yaghoub61
    Yaghoub61 is offline
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    188

    Re: Select Range formula without Error

    thank you so much !
    Is it possible to use the combination of Counta and Offset functions in vba for this?
    Reply With QuoteRegister To Reply
  4. 03-14-2024, 08:04 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,337

    Re: Select Range formula without Error

    I don't quite understand...Are you not wanting above solution...
    Reply With QuoteRegister To Reply
  5. 03-14-2024, 08:08 AM #5
    Yaghoub61
    Yaghoub61 is offline
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    188

    Re: Select Range formula without Error

    The above solution is wonderful! If it is possible or there is another way, please
    Reply With QuoteRegister To Reply
  6. 03-14-2024, 08:12 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,337

    Re: Select Range formula without Error

    But why another way if above does what is required...
    Please Login or Register  to view this content.
    Last edited by sintek; 03-14-2024 at 08:25 AM.
    Reply With QuoteRegister To Reply
  7. 03-14-2024, 09:37 AM #7
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,308

    Re: Select Range formula without Error 

    Please Login or Register  to view this content.
    should do the trick.
    Anyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  8. 03-16-2024, 02:07 PM #8
    Yaghoub61
    Yaghoub61 is offline
    Forum Contributor
    Join Date
    05-21-2019
    Location
    Tabriz,Iran
    MS-Off Ver
    2010
    Posts
    188

    Re: Select Range formula without Error

    Thank you ! that was perfect! I want it to select the data after selection and then copy it to the second sheet below.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Error - when select a range instead of the whole row
    By shido in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-12-2015, 08:53 AM
  2. Error when trying to select a Range
    By viktormu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2011, 02:36 AM
  3. Subscript out of range error when trying to select a range
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2010, 07:57 PM
  4. [SOLVED] Range.Select error and screen maximizing error in Workbook_Open()
    By Punsterr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2006, 05:20 PM
  5. [SOLVED] Range.Select error and screen maximizing error in Workbook_Open()
    By Punsterr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2006, 03:00 PM
  6. Can't select range. Why the error?
    By agentsmith83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2006, 11:40 AM
  7. [SOLVED] Help with this error Unknown reason for error with Range().Select
    By Brad Sumner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 12:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1