Thanks Rick,

That does do what I asked :o)

not quite what I was hoping for though, not sure if it would be
possible, instead of still selecting the upper left cell I want each
cell under the cursor as it moves to be selected individually.

On 17 Dec, 16:53, "Rick Rothstein"
wrote:
You can do it with VBA code. Right click the tab at the bottom of the
worksheet you want to have this functionality, select View Code from the
popup menu that appears and copy/paste this code into the code window that
opened up...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
* Target(1).Select
End Sub

Now, go back to that worksheet and try to select multiple cells.

--
Rick (MVP - Excel)

"Marge" wrote in message

...



Is it possible with VBA the make a sheet select only one cell at a
time when you drag the cursor around the sheet instead of the normal
function of selecting a range?- Hide quoted text -

- Show quoted text -