+ Reply to Thread
Results 1 to 3 of 3

VB Code to fillup zero

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,313

    VB Code to fillup zero

    Hello:

    Please refer to attached file.
    I need VB Code to do following.
    Need to find "None" in column J and change to "0"

    Need to Go thru data from column D thru S and if it is blank then change to "0"


    Let me know if you have any questions.
    Thanks.


    R
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Cool Re: VB Code to fillup zero


    According to your attachment as a VBA beginner starter :

    PHP Code: 
    Sub Demo1()
        
    With Sheet1.UsedRange.Columns:  .Item(10).Replace "None"0:  .Item("D:S").Replace Empty, 0:  End With
    End Sub 
    ► Do you like it ? ► ► So thanks to click on bottom left star icon Add Reputation ! ◄ ◄
    Last edited by Marc L; 05-18-2020 at 12:26 PM. Reason: revamping ‼

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,313

    Re: VB Code to fillup zero

    Hello Marc

    Thanks a lot

    Riz

+ 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. Auto fillup colomns data from different spreedsheets into a mastersheet
    By Kaustavlegend in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-31-2020, 09:49 AM
  2. [SOLVED] Using .FillUp and Array Formula - Unsuccessfully
    By midwestjon in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-08-2019, 05:12 PM
  3. [SOLVED] FIllup empty cells MACRO
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2016, 03:53 PM
  4. [SOLVED] auto fillup of days/date of month
    By iamhsn in forum Excel General
    Replies: 3
    Last Post: 05-18-2012, 11:05 PM
  5. fillup the Branches productivity
    By migdad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2011, 06:11 AM
  6. [SOLVED] Autofill:already fillup coding
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2005, 10:06 AM

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