View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveM[_2_] DaveM[_2_] is offline
external usenet poster
 
Posts: 77
Default Highlighting Rows and Cut to another worksheet

Hi

Excel 2002

sheet1 Column A this is formatted as Text

0001
0001
0002
0002
0002
0002
0002
0003
0003


I would like to hightlight the Rows of the first series of numbers, in this
case Rows A1,A2
Cut and paste them in sheet2, leaving......

0002
0002
0002
0002
0002
0003
0003


and when I use the code again it would move the 0002s

Thanks in advance

Dave