How to skip rows with value in a column using next available row code

**fremarco** · 08-13-2012, 10:39 PM

Good Day All

The following code I am using to populate a worksheet, from a userform, is working well but I would like to skip rows if they have a value in column B. I have been searching the forum and Google but can't figure it out. Is there a way to add a piece of code to do this or do I need to reconstruct?

Thanks for your time everone

Please Login or Register  to view this content.

**rylo** · 08-13-2012, 11:58 PM

Hi

Are you saying that you may have an item in column B that is further down than the last item in column A, or that if the offset from LastRow contains data, you don't want it to be overwritten?

rylo

**fremarco** · 08-14-2012, 12:16 AM

Hi Rylo. Thanks for responding

The answer is yes, and yes. Basically, after the userform has inputed data to rows A32/A33, I am trying to skip to row A49. Does that make sense?

Cheers

Fred

**mikerickson** · 08-14-2012, 12:23 AM

Change to

Please Login or Register  to view this content.

**fremarco** · 08-14-2012, 01:01 AM

Thanks Mike. It works a treat. All the best to you

Fred

How to skip rows with value in a column using next available row code

LinkBack

Thread Tools

Rate This Thread

Display

How to skip rows with value in a column using next available row code

Re: How to skip rows with value in a column using next available row code

Re: How to skip rows with value in a column using next available row code

Re: How to skip rows with value in a column using next available row code

Re: How to skip rows with value in a column using next available row code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions