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?
Bookmarks