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