+ Reply to Thread
Results 1 to 4 of 4

Exclude certain rows from VBA Code

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    364

    Exclude certain rows from VBA Code

    Hi all

    I am using the following code to highlight my current row.

    Please Login or Register  to view this content.
    However, this does not seem to work on the sheet I need it to. (It works fineon all other sheets in the workbook).
    I assume it is because there are several references in the first 7 rows that are used in other VBA Codes.

    Therefore, I'd like to exclude the rows from my code. But unfortunately I have not figured out how to do this.

    Could anyone please tell me how I can modify the code, so that it only takes effect on rows 7<

    Thanks

    FD

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Exclude certain rows from VBA Code

    You need to attach the workbook

    To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
    To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

    On this page, below the message box, you will find a button labelled 'Manage Attachments'.
    Clicking this button will open a new window for uploading attachments.

    You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
    Alternatively you can click the Attachment Icon to open this page.

    To upload a file from your computer, click the 'Browse' button and locate the file.

    To upload a file from another URL, enter the full URL for the file in the second box on this page.
    Once you have completed one of the boxes, click 'Upload'.

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    364

    Re: Exclude certain rows from VBA Code

    Unfortunately I cannot upload the file due to privacy reasons.
    However, all I would need to know is how I can exclue the fist 7 rows from the VBA Code.

    Sorry about that...

  4. #4
    Forum Contributor
    Join Date
    12-28-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    280

    Re: Exclude certain rows from VBA Code

    You could include the following line after your Dim i As Long:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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