#1
|
|||
|
|||
new thread
in my excel file, only i need to do click
on first click on cell, get one, then two like this so on this below vb code, is gave an idea row name, but i need on click one, two , three, four so on 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 once again Thank jb Edit/Delete Message |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why nobody marks his thread as solved?! | Catalin.B | Excel | 0 | 08-24-2011 06:23 AM |
Yet Another Missing Email Thread | DrewD | Outlook | 4 | 08-19-2011 01:51 PM |
Publisher 2003 Help making even spaced dots (Thread has 2 images for examples) | Blitz55 | Publisher | 3 | 10-29-2010 01:25 PM |
Mark a thread as solved | Matrix | Forum Support | 0 | 04-22-2009 04:48 PM |