ExcelBanter - How do I advance the range by one row Excell VBA automatically

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I advance the range by one row Excell VBA automatically (https://www.excelbanter.com/excel-discussion-misc-queries/10435-how-do-i-advance-range-one-row-excell-vba-automatically.html)

Eric

How do I advance the range by one row Excell VBA automatically

I am using

Sheets(Array("Breakfast", "Lunch", "Supper", "Bedtime")).Select
Range("B94:D98").Select

but when I run this more than once it overwrites what was put in the first
time.

All times are GMT +1. The time now is 11:14 PM.