Hi,

I have a list of variables all defined by offsets (due to the way a loop works)

Example list:
Notional = setRange.offset(40, 6).Value
Product = setRange.offset(40, 81).Value
ValueX= setRange.offset(40, 30).Value
TypeX= setRange.offset(40, 82).Value
)

I would like to copy these to another area of the sheet off to the side

For example i want notional to go to 40,97 and product to 40,98 and so on.

Whats the best way for me to copy these figures to their new location using the offset function?

Thanks.