+ Reply to Thread
Results 1 to 2 of 2

loop algorithm instead of Recording in macro

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    18

    Talking loop algorithm instead of Recording in macro

    Dear Mr/Guru/Rabbi/Prof/Teacher of Excel :
    any help about my task to create a macro, i cant use record because exported data is random in size.

    after exported to excel id like to :
    delete these columns. : A, D, ,E, G I, J,L,M,O,Q,S,U
    then back to A1,
    i usually press ctrl-down arrow to go to cells contains text, shift-rightarrow, press ctrl-R, then left-arrow then rightarrow then press delete, and then
    i press again
    i usually press ctrl-down arrow to go to cells contains text, shift-rightarrow, press ctrl-R, then left-arrow then rightarrow then press delete, and then
    i press again
    i usually press ctrl-down arrow to go to cells contains text, shift-rightarrow, press ctrl-R, then left-arrow then rightarrow then press delete, and then
    .
    .
    .
    .(picture attached)
    .
    .
    .

    until the end,
    so these process id like to make a macro, i cant use record macro, because every exported file is not the same in size. sometimes huge, sometime a little.

    Thx
    Attached Images Attached Images
    Last edited by sr_88; 08-19-2016 at 01:16 AM. Reason: to be google searchable

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: need help to create my macro for my task, thx in advance :)

    ...deleted...
    Last edited by FDibbins; 08-19-2016 at 10:51 AM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Please Help - Need Macro Coding to create Timmer for the task
    By Aswinraj1989 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2015, 12:54 PM
  2. Macro for advance filter to create separate worksheet and workbook based on criteria
    By bossrockzz in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-18-2014, 02:36 PM
  3. Create Outlook task from Excel Macro?
    By Jay Harris in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2013, 11:11 PM
  4. Macro to create a task in outlook and send it to specific recipients
    By JacksonBoss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2012, 01:24 PM
  5. Mega task to create a macro form based DB
    By psanghvi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2011, 04:01 PM
  6. How to create a macro to change the text color as i advance
    By tarnold in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2008, 04:26 PM
  7. [SOLVED] [SOLVED] Create MS Outlook task object by Excel macro
    By Ivan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2006, 12:55 AM

Tags for this Thread

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