For Each rCell Query

**timbo1957** · 10-18-2011, 05:49 AM

Hi,

I have a piece of code which looks like this

Please Login or Register  to view this content.

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.

**romperstomper** · 10-18-2011, 05:54 AM

Assuming column A always has data for each row:

Please Login or Register  to view this content.

**teylyn** · 10-18-2011, 05:56 AM

Hello,

find the last row with code like

Please Login or Register  to view this content.

cheers,

**timbo1957** · 10-18-2011, 05:58 AM

Thanks romperstomper, just what I needed.

For Each rCell Query

LinkBack

Thread Tools

Rate This Thread

Display

For Each rCell Query

Re: For Each rCell Query

Re: For Each rCell Query

Re: For Each rCell Query

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions