+ Reply to Thread
Results 1 to 6 of 6

Problem loop another non continious range to other sheet

  1. #1
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,512

    Problem loop another non continious range to other sheet

    i want delete cell blank in loop sheet
    But still error
    Any idea ????

    This is my picture and myfile Screenshot_127.png
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by daboho; 09-28-2018 at 08:06 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Problem loop another non continious range to other sheet

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,512

    Re: Problem loop another non continious range to other sheet

    my data is so very big,so coding is very hard
    after copy any data is blank ,i am delete blank cell in other sheet but error
    can you help me
    MY FILE HAS UPLOAD IN post #1
    Please Login or Register  to view this content.
    Last edited by daboho; 09-28-2018 at 05:26 AM.
    "Presh Star Who has help you *For Add Reputation!! And mark case as Solve"

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Problem loop another non continious range to other sheet

    It errors only when the sheet does not have blanks and nothing to delete.

    This will ignore the error
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,512
    Quote Originally Posted by AlphaFrog View Post
    It errors only when the sheet does not have blanks and nothing to delete.

    This will ignore the error
    Please Login or Register  to view this content.
    Still error my friend

  6. #6
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,512
    Quote Originally Posted by AlphaFrog View Post
    It errors only when the sheet does not have blanks and nothing to delete.

    This will ignore the error
    Please Login or Register  to view this content.
    Any idea with other coding
    I want to using array but i dont know
    How to delete key(i) in array
    After loop
    Example
    If key(1) has sucses export data ti sheets("A")
    Then delete data in array
    Sn="" if key (1) has executed
    Then looping again key(2)
    Then delete again in array
    Any idea my friend

+ 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] loop range in sheet 3 to find value and copy offset cell to sheet 2
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2017, 09:58 AM
  2. Continious running clock
    By Cheecochongo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2016, 12:51 PM
  3. Problem using loop for sending excel range in email body using Range to HTML code
    By drajanm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2012, 03:17 AM
  4. Loop and range problem
    By jalea148 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 03:24 PM
  5. problem with Range statement in With-End With loop
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2010, 04:19 AM
  6. Looking for a function to add continious string.
    By onetinylife in forum Excel General
    Replies: 7
    Last Post: 10-19-2009, 03:11 PM
  7. getting the first and last value out of a non continious data set
    By withy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-23-2009, 03:55 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