VB.NET & Excel Problem

Question

I am trying to copy a range form an excel worksheet to another worksheet (same workbook). Currently I have a worksheet with a date in each column and data underneath them. I search for the date, offset the row down one so the active cell is the first cell of data. What I wish to do now is have code that can select down several cells, probably a fixed number eg. 6 cells down, and copy them. I have tried to record a macro in excel but it sheds no light on the issue. Any ideas/code would be helpful. Thanks!