View Single Post
  #1   Report Post  
Eric
 
Posts: n/a
Default 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.