View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Touk Touk is offline
external usenet poster
 
Posts: 2
Default Range.delete method

Hi, I have a list of numbers about 6 characters in length
listed in a spreadsheet. I would like to delete the first
2 numbers that appear in the cell eg (217000 I want to
delete "21" so that only 7000 appears in the cell). Am I
able to use the Range.delete method to do this in VBA or
is there another way I can do this? After this is done I
can then easily filter that list. Please advise the
easiest way to do this.