Excel

I need to use some vb code to select just the filled cells in column c from c2 down (attached sheet) but this column will hold variable numbers of vales
Book11.xls
doctorbillTechAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

Range(Range("C2"), Range("C" & Cells.Rows.Count).End(xlUp)).Select

Open in new window

Regards
0
 
doctorbillTechAuthor Commented:
excellent - thanks
0
 
doctorbillTechAuthor Commented:
solved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.