rajkumar
08-29-2008, 11:01 AM
Hi,
I have tried Auto Numbering code in the knowledge base, it is amazing!
'Put this code In the sheet module:
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim RowOffset As Long
Dim IndexCol As String
'Set values
RowOffset = 0
'Change the C to the column where you want the numbers to show
IndexCol = "C"
Intersect(ActiveCell.EntireRow, Columns(IndexCol)).Value = ActiveCell.Row + RowOffset
End Sub
But it starts from cell A1, where as my data starts from 7th Row.
Can any body help me how to change this to work from Row no 7.
Thanks in advance
Raj
I have tried Auto Numbering code in the knowledge base, it is amazing!
'Put this code In the sheet module:
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim RowOffset As Long
Dim IndexCol As String
'Set values
RowOffset = 0
'Change the C to the column where you want the numbers to show
IndexCol = "C"
Intersect(ActiveCell.EntireRow, Columns(IndexCol)).Value = ActiveCell.Row + RowOffset
End Sub
But it starts from cell A1, where as my data starts from 7th Row.
Can any body help me how to change this to work from Row no 7.
Thanks in advance
Raj