+ Reply to Thread
Results 1 to 4 of 4

Macro to Enter zero for blank range of cells, but not past the last row of data

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Macro to Enter zero for blank range of cells, but not past the last row of data

    Hello All,

    I am wanting to know if this is possible... "Macro to Enter zero for blank range of cells, but not past the last row of data"

    Each macro I have reviewed adds rows below to the existing table.

    If there is a source to solve this question I would appreciate if I could be pointed in the right direction...

    Regards,

    John

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Macro to Enter zero for blank range of cells, but not past the last row of data

    Try something like this.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,562

    Re: Macro to Enter zero for blank range of cells, but not past the last row of data

    Please Login or Register  to view this content.
    Experience trumps academics every day of the week and twice on Sunday.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,562

    Re: Macro to Enter zero for blank range of cells, but not past the last row of data

    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. Userform to enter new data in first blank cell of a dynamic range
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2018, 12:02 AM
  2. [SOLVED] macro to copy data range from sheet and past to specific other sheets
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-31-2017, 05:31 AM
  3. vba code to be able to past into the next specified range in the next blank row
    By markswan111 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-27-2016, 10:23 AM
  4. Tell macro to skip blank cells in a range and only select those with data?
    By Belinea2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2016, 08:33 PM
  5. Insert rows and enter data in blank cells.
    By jscalem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-22-2013, 06:47 AM
  6. [SOLVED] Macro for COPY and PAST RANGE of data to ANOTHER workbook
    By Atoms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 02:45 AM
  7. macro to enter data in next blank cell
    By Karen311261 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2010, 04:00 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