Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For loop with non consecutive number
Hi guys!
I need some help ! I want to know if its possible to loop wit different numbers like that: CellArray = Array(1, 2, 5, 10) 'the i should take 1, after 2, after 5, after 10 Worksheets("Mold base").Activate LargMoule = Range("c2").Value LongMoule = Range("d2").Value LargeurParallele = Range("o47").Value ActiveCell = Range("d17").Activate ActiveCell.Value = "Largeur" For i = 1 To UBound(CellArray) If IsEmpty(ActiveCell.Offset(i, -1)) = False Then ActiveCell.Offset(i, 0) = LargMoule ActiveCell.Offset(i, 1) = LongMoule Largeur(i) = LargMoule Longueur(i) = LongMoule End If thanks a lo -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the Number of Consecutive Ranges | Excel Worksheet Functions | |||
Excel and consecutive number | Excel Worksheet Functions | |||
how to consecutive number same worksheet | New Users to Excel | |||
Count Consecutive string of same number | Excel Worksheet Functions | |||
How do i automaticaly number consecutive forms | Excel Worksheet Functions |