Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Offset | Excel Discussion (Misc queries) | |||
Offset. | Excel Worksheet Functions | |||
Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
Offset | Excel Programming |