In VB in have cell references to the column and row numbers

example

column = 35

Row = 6

I would like to do a offset type function to select the cell and then the next 10 columns along.

The result would be AI6:AS6

From here im planning to copy this range and post it somewhere else.

The column references are likley to change alot which is why i cant just use AI6:AS6


Please can someone help?