I have a range defined and what I'd like to do is redefine another range
programmatically that includes everything but the first row of the initial
range. Can someone assist?

Thanks

dim myRng as range
dim my2ndRng as range

with worksheets("sheet9999")
set myrng = .range("somerangenamehere") 'or something
end with

with myrng
set my2ndrng = .resize(.rows.count-1,.columns.count).offset(1,0)
end with



Barb Reinhardt wrote:

I have a range defined and what I'd like to do is redefine another range
programmatically that includes everything but the first row of the initial
range. Can someone assist?

Thanks

--

Dave Peterson