+ Reply to Thread
Results 1 to 3 of 3

Repeat the following action in ALL sheets

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Repeat the following action in ALL sheets

    Hello. I want to do the following in all sheets that have data in B2 (the data will start in B2 but there will be more data below in column B): Text to columns, delimiter, space. Then, select all data that has been expanded from column B, autofit columns, and apply accounting format. Please explain each piece of the code. Thanks

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Repeat the following action in ALL sheets

    Why not use the macro recorder and step through the process on one sheet to get some basic code to work with...?

    This can then be rationalised and applied to all sheets.

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: Repeat the following action in ALL sheets

    Ok, but can you provide me with the code for applying to all sheets?

+ 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] How to repeat an action in other columns?
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-02-2013, 07:41 AM
  2. Repeat last action
    By Teri in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-13-2006, 11:15 AM
  3. [SOLVED] repeat an action in different locations
    By countrypotter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  4. [SOLVED] repeat an action in different locations
    By countrypotter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] repeat an action in different locations
    By countrypotter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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