+ Reply to Thread
Results 1 to 4 of 4

VB Code to clean up data which has Merged Data by deleting blank rows & Columns

  1. 07-21-2019, 11:50 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to clean up data which has Merged Data by deleting blank rows & Columns

    Hello:

    Please refer to attached file.
    Attatched file has data with Merged Text and lots of hidden blanks rows and blank columns.
    I need VB Code to delete all blank rows and blank colums and make this as usable excel file with data in each rows.

    Let me know if you have any questions.
    Thanks.

    R
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-21-2019, 12:54 PM #2
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,056

    Re: VB Code to clean up data which has Merged Data by deleting blank rows & Columns

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 07-21-2019, 01:02 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to clean up data which has Merged Data by deleting blank rows & Columns

    Hello Mumps1

    Thanks a lot..

    R
    Reply With QuoteRegister To Reply
  4. 07-21-2019, 01:06 PM #4
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,056

    Re: VB Code to clean up data which has Merged Data by deleting blank rows & Columns

    My pleasure.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cleaning rows of data and clean rows of duplicates not deleting.
    By guidom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2014, 12:48 PM
  2. Deleting Blank Rows than Organize Data from A to Z
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2013, 12:01 AM
  3. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  4. [SOLVED] VBA Code to optimize and clean data- clean out numerical/ or symbol
    By tracylsr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 04:21 PM
  5. [SOLVED] VBA Code to optimize and clean data - Round II Merge columns
    By JoaoVr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2012, 05:58 AM
  6. Transposing data from rows into columns (columns have been merged)
    By TommyGato in forum Excel General
    Replies: 8
    Last Post: 11-02-2011, 02:45 PM
  7. VBA Code to read the structure & data of an excel sheet having merged rows & columns
    By alam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2007, 02:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1