Results 1 to 4 of 4

For Each rCell Query

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro Plus 2021
    Posts
    424

    For Each rCell Query

    Hi,

    I have a piece of code which looks like this

    For Each rCell In Range("A2:AF300").Rows
    Is it possible to change it so that the start point is A2 but the end point is the last row containing data? The last column will still be AF but the row will be variable.

    Thanks

    Tim.
    Last edited by timbo1957; 10-18-2011 at 05:57 AM.

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