+ Reply to Thread
Results 1 to 4 of 4

VBA string for dragging data to last blank row in a series of blank cells in a column

  1. #1
    Registered User
    Join Date
    04-25-2019
    Location
    Michigan, United States
    MS-Off Ver
    2010
    Posts
    2

    Post VBA string for dragging data to last blank row in a series of blank cells in a column

    Hello,
    Currently, I am trying to fill in the blank cells in column B with the code found above it. There is no predictable spacing between codes and I have tried using the same formula in VBA used for dragging contiguous data to the end of the last blank row with no success. I have attached an example sheet. You will see there are various formula codes in column B...unfortunately, I need the codes in the blank cells beneath it in order to glean the necessary data from the adjacent columns.

    Thank you for any help!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    11,743

    Re: VBA string for dragging data to last blank row in a series of blank cells in a column

    Hi & welcome to the board.
    How about
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-25-2019
    Location
    Michigan, United States
    MS-Off Ver
    2010
    Posts
    2

    Re: VBA string for dragging data to last blank row in a series of blank cells in a column

    Wow, this worked perfectly. I am very new to VBA scripts and this was very helpful. Thank you!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    11,743

    Re: VBA string for dragging data to last blank row in a series of blank cells in a column

    You're welcome & thanks for the feedback

+ 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. [SOLVED] Dragging formula to add two columns, but need to show blank when other cell is blank
    By doesntexist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2018, 11:18 PM
  2. [SOLVED] Need to make Sum Column blank if all cells being added are blank
    By JediDA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2018, 10:23 PM
  3. Replies: 6
    Last Post: 03-01-2018, 12:16 PM
  4. Dragging the fill handle leaves cells blank
    By LandonD in forum Excel General
    Replies: 2
    Last Post: 12-21-2016, 10:19 PM
  5. Replies: 11
    Last Post: 09-15-2014, 02:36 AM
  6. Replies: 4
    Last Post: 06-24-2013, 07:17 AM
  7. Replies: 0
    Last Post: 03-05-2013, 09:22 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