Is there something in vba that will allow me to select a certain amount of
columns by variable?

I have a sum that is formulated on sheet1. I need to figure out how to
select that many columns starting at b1 on sheet 2. If it matters I need to
have 5 rows by ever how many columns.

thanks so much for your help!