View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default Insert a number a number in column

IF the value is 100000 lower than it should be, then you can do it in
one step - put 100000 in one blank cell, copy it, then select the other
cells as a block - now, edit paste special, use the ADD option to add
this value.