--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack" wrote in message
...
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!