User Profile

Collapse

Profile Sidebar

Collapse
boaring
boaring
Last Activity: Feb 2 '07, 04:02 PM
Joined: Sep 2 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • boaring
    started a topic Query day of week
    in Access

    Query day of week

    Hi, I wish to compare the sales figures over a period of time - but only FRIDAYS to see the effect of a project implemented on fridays?
    I have a DATE field & a SALES field among others.
    See more | Go to post
    • boaring
      replied to Excel Macro: incrementing "Sheets"
      in Visual Basic
      Hi Dave,
      Thankyou very much! Works like a dream. Now I can use any macro and have it repeated 31 times :)
      See more | Go to post

        Leave a comment:

      • boaring
        started a topic Excel Macro: incrementing "Sheets"
        in Visual Basic

        Excel Macro: incrementing "Sheets"

        I need to use Macro's in Excel and always the same changes to 31 Sheets. (31 days in the Month).
        I'm trying to use a FOR loop but cannot get the correct format to have the sheet number to increment by 1 in each loop.
        Below is a silly little Macro but indicates what my problem is.
        I have tried inserting my variable intSheet in various ways including concatenation to no avail.
        Any help would be greatly appreciated.
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...