Offset

[ceemo]

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?

[bpeltzer]

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

[Ron de Bruin]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[ceemo]

perfect thank you very much