name selection

[my.wandering.mind]

Hi All,

I have a table which has one blank row between row 1 and row 3 and
then there are several rows of data. How Can I name this range in vba

I cannot delete the blank row

Any suggestions?

thanks
vishnu

 

[Mike H]

assumes excel 2003<

Set myrange1 = Rows(1)
Set myrange2 = Range(Cells(3, 1), Cells(7, 256))
Set myrange = Union(myrange1, myrange2)

Mike