Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Find Cell in a range if Empty insert 0

    HI All,


    I need a code that search empty cells in range suppose A1 to Z100 if find empty cell then insert zero?


    Thanks and Regards,
    Farrukh Hameed

  2. #2
    Lounger
    Join Date
    Apr 2012
    Location
    Abergavenny, Wales, UK
    Posts
    25
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Hi

    You can do it without code.
    1. First select your range of Data - A1:Z100
    2. Press F5 and click Special
    3. Select Blanks and click OK
    4. Type a 0 into any of the cells that have been selected and the press Control + Enter

    Provided you press Control + Enter the 0 will be inserted into all the blank cells selected. Pressing Enter on its own, will only insert a 0 into the active cell.
    Regards
    Roger Govier
    Microsoft Excel MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •