+ Reply to Thread
Results 1 to 13 of 13

Formatting Macro

Hybrid View

  1. #1
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Formatting Macro

    Cardan

    I did open the file, how do you think I found out the first row of data is 19 and not 11?

    What I didn't do is run the JobCodeOutput.

    It's a bit late here to do that now but I'll give it a try tomorrow.
    If posting code please use code tags, see here.

  2. #2
    Registered User
    Join Date
    07-26-2006
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Formatting Macro

    Yes you are right. the headers are in row 18 and the data starts in 19. To run the job code macro, first delete all the tabs named Job xxxx. the macro creates these and if the already exist, you get an error.

    No worries about the time. I greatly appreciate the effort.

+ 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. Macro for formatting fonts and cell colours - not Conditional Formatting
    By Kayaness in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2011, 03:46 AM
  2. Pivot Table graph looses formatting after running formatting macro
    By arthurbr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2011, 04:16 AM
  3. Conditional formatting macro (highlight macro)
    By c991257 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 02:46 PM
  4. Macro Formatting? Please Help
    By Plasmaticfire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2006, 03:05 PM
  5. RE: Macro Formatting? Please Help
    By Gary Brown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2006, 01:14 PM

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