Macro: Select cells A:K in the 'next row down'

Posted by richard on January 19, 2002 12:49 AM

This is probably an easy one but its baffling me! I want my macro to 'go to the 'next row down and select the cells in range A:K'. However, I do not want to specify the number of the row (e.g. A4:AK) - just simply A:K in 'the next row down'(whatever row number that may be).

Any ideas?

Posted by Gary Bailey on January 19, 2002 4:51 AM

intersect(range("a:k"),activecell.Offset(1,0).EntireRow).Select