View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default excel same value in two cells

Doing a final test with:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.Value = Target.Value + 1
End Sub

stops at 346 so I would gues that is where VBA is giving it up.

We must have no "honey-do" list


I do have a "honey-do" list but I don't have a circular Tuit - I keep
telling my wife that I will do the tasks when I get a round Tuit

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk