文書番号: 402277
最終更新日: 1997/10/20
Sub RowCellno() Dim cellrange As String Dim rowno,colno As Integer cellrange = Range("sheet1!A19").Value rowno = Range("sheet1!" & cellrange).Row colno = Range("sheet1!" & cellrange).Column Worksheets("sheet1").Activate Cells(rowno, colno).Select End Sub
Sub RowCellno2() Dim cellrange As String Dim rowno,colno As Integer cellrange = Range("sheet1!A19").Value On Error Goto ErrorHandler rowno = Range("sheet1!" & cellrange).Row colno = Range("sheet1!" & cellrange).Column Worksheets("sheet1").Activate Cells(rowno, colno).Select Exit Sub ErrorHandler: MsgBox "セル参照が無効です。" End Sub
Sub RowCellno3() Dim cellrange As String Dim rowno As Integer Dim colno As Integer Dim Point cellrange = Worksheets("sheet1").Cells(19,1).Value 'cellrange = Range("sheet1!A19").Value でも可能 If Left(cellrange, 1) <> "R" Then GoTo ErrorHandler End If Point = Application.Search("c", cellrange, 1) If IsError(Point) Then GoTo ErrorHandler End If On Error GoTo ErrorHandler rowno = CInt(Mid(cellrange, 2, Point - 2)) colno = CInt(Right(cellrange, Len(cellrange) - CInt(Point))) rowno = Worksheets("Sheet1").Cells(rowno, colno).Row colno = Worksheets("Sheet1").Cells(rowno, colno).Column Worksheets("sheet1").Activate Cells(rowno, colno).Select Exit Sub ErrorHandler: MsgBox "セル参照が無効です。" End SubAdditional reference words: cell row column reference number indirect 参照
Keywords: KBHOWTO KB402277
Technology: kbExcel500 kbExcelSearch kbExcelWinSearch