macro help

[Dummy Excel]

Hi All,
I have some data that I need to select, my formula is:
Range("I8:S8").Select
Range(Selection, Selection.End(xlDown)).Select

The problem with this is that once it sees one blank (empty) cell it stops, and there is probably another 10 rows of data I need to capture. is there a way that I can rewrite the code to say once all the cells are empty in the range of columns I to S then select all that???

any help is greatly appreciated
Sam

 

[mikerickson]

Range("S65536").End(xlup)

will return the last entry in column S, even if there are blanks above it.

Does that help?

 

[Dummy Excel]

thanks for your help mikerickson - unfortunately I cant do that as I have a chart under the data - I need the chart there so that I can print the data and chart on one sheet.

Sorry I shouldve mentioned that in my original post

 

[mikerickson]

A chart doesn't interfere with that. The code only looks at what is in cells, not at what is embedded in the sheet.