+ Reply to Thread
Results 1 to 5 of 5

Check First, if range have then skip the worksheet_Change Event

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Check First, if range have then skip the worksheet_Change Event

    hi, everyone

    i am using below code to copy and fill down the data

    Please Login or Register  to view this content.
    i want little change in above worksheet_change event

    first code check the range (A11:A2000)
    if this range have already data then do nothing otherwise copy and fill down data as code does

    thanx
    Use Code-Tags for showing your code :
    Please mark your question 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 using STAR *

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Check First, if range have then skip the worksheet_Change Event

    Would this work?
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Check First, if range have then skip the worksheet_Change Event

    @gmr4evr1
    THANX FOR REPLY

    But i think something is wrong with code, because nothing is hapening if range a11:a2000 have data or not
    Last edited by HaroonSid; 02-20-2017 at 01:12 AM.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Check First, if range have then skip the worksheet_Change Event

    I do not knwo what all the rest of the code must do but it does work like this:

    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Check First, if range have then skip the worksheet_Change Event

    Maybe:

    Please Login or Register  to view this content.

+ 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. Check if event occurs within time range
    By excellinginlife in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-20-2016, 10:43 AM
  2. How do I use the worksheet_change event?
    By JohnJK04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2015, 07:51 PM
  3. [SOLVED] Simple Worksheet_Change Event Syntax Check
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-06-2014, 08:04 PM
  4. Before save event and check if any cells in the specific range are left blank
    By Khowailedg in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-26-2013, 01:33 PM
  5. Worksheet_Change Event won't run more than once
    By David McMillon in forum Excel General
    Replies: 2
    Last Post: 07-08-2010, 04:02 PM
  6. Using Named Range in Worksheet_Change event
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 04:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1