Selecting entire row when content is found in specific columns

**skylerjo** · 09-22-2012, 02:34 PM

Hi I need some help, I need a macro that will Select the entire row (and continue to select as it moves down the workbook, like cntrl clicking) any time their is content of any kind found in columns P-T. I am new to VBA language and I am having a hard time creating a code for this. It is quite a large file(close to 9000 rows). What's a code I can do for this? Thank you!

**thameem127** · 09-22-2012, 02:38 PM

Mr.skylerjo

Welcome to the forum.Upload your file to solve your problem.

**thameem127** · 09-22-2012, 05:21 PM

I think your need is to select 9000 rows at a time with one click . Is it is right?

**Bishonen** · 09-22-2012, 05:23 PM

i thought that even I could write a code for this. Boy, was I wrong :D

Here's what I came up with. Someone care to explain where my mistake is?

Please Login or Register  to view this content.

**Bishonen** · 09-22-2012, 05:24 PM

duplicated post due to forum failure :/

heres an updated version of the code tho:

Please Login or Register  to view this content.

It only selects the last column which is non empty. Adding false behind Select returns an error. Whyyyy ?^^

PS: Yes, I noticed that the code isn't a solution for the OP (its late over here

). But could someone still point out what i was doing wrong? I'd like to select an entire row if its not empty..