Offset
 

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

Offset
 

Range(Selection, Selection.Offset(0,11)).Select


"ceemo" wrote:


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

Offset
 

Use this

Sub test()
Dim Columnnum As Integer
Dim Rownum As Long
Columnnum = 35
Rownum = 6
Cells(Rownum, Columnnum).Resize(1, 10).Select
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ceemo" wrote in message
...

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

Offset
 

perfect thank you very much


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