D
Dave Neve
Hi
I'd like to add instruction to the macro below to place the cursor in the
selected cell.
I've tried to work it out using record macro but the mouse doesn't respond
in this mode.
Could sm be so kind as to add the line of code in .
Thanks
Sub RandomPick()
'
' RandomPick Macro
' Macro créée le 18/06/2005 par Dave Neve
'
Dim i As Long
Dim j As Long
i = Selection.Tables(1).Rows.Count
Randomize
j = Int((i * Rnd) + 1)
Selection.Tables(1).Cell(j, Selection.Tables(1).Columns.Count).Select
I'd like to add instruction to the macro below to place the cursor in the
selected cell.
I've tried to work it out using record macro but the mouse doesn't respond
in this mode.
Could sm be so kind as to add the line of code in .
Thanks
Sub RandomPick()
'
' RandomPick Macro
' Macro créée le 18/06/2005 par Dave Neve
'
Dim i As Long
Dim j As Long
i = Selection.Tables(1).Rows.Count
Randomize
j = Int((i * Rnd) + 1)
Selection.Tables(1).Cell(j, Selection.Tables(1).Columns.Count).Select