+ Reply to Thread
Results 1 to 15 of 15

Fill Empty Cell with Zero

  1. 06-15-2019, 05:16 AM #1
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Fill Empty Cell with Zero

    Hi,

    Can any somebody help me to solve to fill zero (if cell is blank) in multiple sheets but need to ignore certain sheets i.e Sheet1, Sheet2 and Sheet4. Below is the code I got from site which works on activesheet.

    Please Login or Register  to view this content.
    Regards,
    Reply With QuoteRegister To Reply
  2. 06-15-2019, 06:12 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: Fill Empty Cell with Zero

    You don't need to loop through the range.

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 06-15-2019, 06:17 AM #3
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Fill Empty Cell with Zero

    hi how I can apply to multiple sheets, above code works only on activesheet.
    Reply With QuoteRegister To Reply
  4. 06-15-2019, 08:02 AM #4
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Fill Empty Cell with Zero

    I need to apply this to all sheets in workbook
    Reply With QuoteRegister To Reply
  5. 06-15-2019, 08:05 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Fill Empty Cell with Zero

    Be patient, please - it is a Saturday.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 06-15-2019, 08:20 AM #6
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Fill Empty Cell with Zero

    Yes Ali, but Saturday is not a week end day over there
    Reply With QuoteRegister To Reply
  7. 06-15-2019, 08:59 AM #7
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Fill Empty Cell with Zero

    How about 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-15-2019, 09:01 AM #8
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Fill Empty Cell with Zero

    Hi !

    As the value of an empty cell is zero or just with a cell formatting it's not very necessary to fill the empty cells with zero ! …
    Reply With QuoteRegister To Reply
  9. 06-16-2019, 02:16 AM #9
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Fill Empty Cell with Zero

    hi,

    I am getting the error message "No Cells were Found"
    Reply With QuoteRegister To Reply
  10. 06-16-2019, 02:24 AM #10
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Fill Empty Cell with Zero

    Quote Originally Posted by Pepe Le Mokko View Post
    Yes Ali, but Saturday is not a week end day over there
    It is in many parts of the world where many forum members live and work, so it is particularly relevant. Forum traffic on a Saturday and Sunday is always significantly less than Monday to Friday. And there is no excuse for impatience.
    Reply With QuoteRegister To Reply
  11. 06-16-2019, 02:44 AM #11
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Fill Empty Cell with Zero

    I suppose that my humor did not get through
    Reply With QuoteRegister To Reply
  12. 06-16-2019, 03:43 AM #12
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Fill Empty Cell with Zero

    No, not at all - it was an hilarious observation.
    Reply With QuoteRegister To Reply
  13. 06-16-2019, 06:30 AM #13
    Barieq
    Barieq is offline
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: Fill Empty Cell with Zero

    Hi,

    Below is the code I made adjustment and now it works. Thanks for you code.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  14. 06-16-2019, 06:30 AM #14
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Fill Empty Cell with Zero

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  15. 06-16-2019, 07:49 AM #15
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Fill Empty Cell with Zero

    Glad you got it working & thanks for the feedback
    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. Need VBA to Fill Empty Cell with Value from Below
    By ShanJé in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-26-2018, 06:23 PM
  2. Fill Empty Cells with above cell
    By johncena in forum Excel General
    Replies: 10
    Last Post: 01-05-2015, 03:57 PM
  3. [SOLVED] Fill until cell is not empty
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2014, 12:11 PM
  4. How to 'no-fill' empty cell that has been highlighted before?
    By airbatucampur92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2014, 12:17 AM
  5. Put formula to cell and fill down to the last non-empty row
    By kingpeejay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2009, 02:44 AM
  6. Pivot Table formatting - Fill empty cell with cell above
    By rmichaels55 in forum Excel General
    Replies: 2
    Last Post: 07-30-2008, 02:42 PM
  7. [SOLVED] fill cell value to the next empty row
    By adey v. in forum Excel General
    Replies: 2
    Last Post: 11-14-2005, 09:55 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