Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alternative copy/delete method needed | Excel Discussion (Misc queries) | |||
Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming |