amateur1902
02-29-2008, 08:41 AM
Hello everyone,
Is het possibel to perform 1 loop for more objects or do i have to loop sepperetly.
Range("F18").Select
ActiveCell.FormulaR1C1 = "=Proper(BDP(RC[-2],""name""))"
Range("N18").Select
ActiveCell.FormulaR1C1 = "=BDP(RC[-10],""VOLUME_AVG_30D"")"
Range("P18").Select
ActiveCell.FormulaR1C1 = "=BDP(RC[-12],""px last"")"
Range("r18").Select
ActiveCell.FormulaR1C1 = "=BDP(RC[-14],""CHG_PCT_1D"")/100"
Is het possibel to perform 1 loop for more objects or do i have to loop sepperetly.
Range("F18").Select
ActiveCell.FormulaR1C1 = "=Proper(BDP(RC[-2],""name""))"
Range("N18").Select
ActiveCell.FormulaR1C1 = "=BDP(RC[-10],""VOLUME_AVG_30D"")"
Range("P18").Select
ActiveCell.FormulaR1C1 = "=BDP(RC[-12],""px last"")"
Range("r18").Select
ActiveCell.FormulaR1C1 = "=BDP(RC[-14],""CHG_PCT_1D"")/100"