please don't kill me if this is indeed a terribly ignorant idea but...
I wanted to try passing range properties like value,formular1c1 and style from an array(which is being held in a variant.
This is an example similar to what I am trying to do:
Is it possible?Sub goodtimes() Properties_array(value,value,style,formular1c1) y = array(1,3,7,8) output = array(stuff,things,"percent","=RC[-1]/RC[-2]") for i = 0 to ubound(y) Cells(y(i),1).properties_array(i) = output(i) next i end sub
Bookmarks