View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
DB. DB. is offline
external usenet poster
 
Posts: 28
Default Increasing easily the number in a cell.

Thanks again, Don. But that solution is rather more complex than
I'd hoped for - this old dog is finding it increasingly difficult to
learn new tricks!
It's getting late here in UK - I must leave it until tomorrow to see
if I can fathom the meaning of your reply.

BW's,
(another) Don


"Don Guillett" wrote in message
...
Right click sheet tabview codeinsert thischange f1 to your cell
address. Now when you right click on the cell the number will be
increased by 2

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Intersect(Target, Range("f1")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = Target + 2
Application.EnableEvents = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DB." wrote in message
...
Thanks for your quick reply, Don.
But holding down the f2 key and hitting "2" appends a 2 to the end
of the number (so that 15016283 becomes 150162832) whereas I want to
increase the number itself by 2 - i.e. for it to become 15016285.
Is there a simple way to do this, please? (And, similarly, a
simple way to subtract that 2 from my original number?).
Thanks again,
--
DB.



"Don Guillett" wrote in message
...
Try touching the f2 key

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DB." wrote in message
...
I have a very large number (8 digits, perhaps) in a cell and
wish to
increase marginally that number (add 2, say) without re-typing
(almost)
the entire string of digits. Is there an easy way (maybe holding
down a
simple key-combination then hitting "2") that will achieve my aim?

TIA of any reply.
--
DB.