View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default If cell contatin string like .... copy in Offset mode

Hi , and a good day everybody

Please to help me with this problem :

I have in a range (f or example : A1:E100 ),
in different cells , numbers like in the follow format /(string)
like :

12-16-18-25-33-43 ;

The other cell contain another values , like :
3 , - , etc .
I need a code to loop through my range cell
by cell , and , IF the value of cell is in string mode like :

17-28-34-36-39-42 ( can be different numbers , but with
the sign - beetwen them )

to copy them in another range , for example G1 ,
useing Offset function , like : Offset ( 1, 0) .

A lot of thanks in advance .