View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Code to delete rows based on value

12173, 12168, 12167, 12165, 12164, 12158, 12153, 11708, 11707, 11706,
11705, 11704, 11703, 11702, 11701, 11498, 11360, 11328, 11327, 11323,
11322, 11314, 11313, 11307, 11302, 11301, 11178, 11172, 11166, 10726,
10725, 10724, 10723, 10716, 10715, 10714, 10713, 10711, 10710, 3045,
3044, 2975, 2972, 2516, 2515, 2514


Here's the problem:this is *not* a comma-delimited string! Instead,
you're using ", " as the delimiter and so you need to do 1 of the
following...

a. remove the spaces
b. revise my code sample to include the space

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion