Resizing range

[Guest]

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]

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