Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy (A2:A26) paste, offset one cell, do it again. Loop 256 tim | Excel Programming | |||
Repost: Copy and Offset cell reference | Excel Worksheet Functions | |||
Find String in Cell then Paste Sum in Offset Cell | Excel Programming | |||
copy offset to cell | Excel Discussion (Misc queries) | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming |