+ Reply to Thread
Results 1 to 3 of 3

Fill empty cells

  1. #1

    Fill empty cells

    I am new to VBA code for excel, and here is my situation. I have
    written a macro and the last part of my macro is to check for the
    following:

    I have a range of cells I have selected, and I need to look throughout
    this range and see if there is any empty cells, if there is...I have
    to fill it with a zero (0) . Does anyone have any code that would
    help me here? Thanks

    M.


  2. #2
    Forum Contributor colofnature's Avatar
    Join Date
    05-11-2006
    Location
    -
    MS-Off Ver
    -
    Posts
    301
    Put this in your macro:

    For Each c in Selection.Cells
    If c.Value = Empty then c.Value = 0
    Next


    Col

  3. #3
    Michael
    Guest

    Re: Fill empty cells

    Thanks soooo much...


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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