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?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=498738