name selection
assumes excel 2003<
Set myrange1 = Rows(1)
Set myrange2 = Range(Cells(3, 1), Cells(7, 256))
Set myrange = Union(myrange1, myrange2)
Mike
" wrote:
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
|