var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Replaceing an array
Any way to remove the array like so
I have cells B2:F2 with this forumla.
I want a the cells to convert to this
I need a vba snippet to do this across a large range. I know I could edit each cell but there is 62500 cells.
One way would be to have a couple of nested loops. Such as,
for i = 1 to 250
for j = 1 to 250
create the new formula using Range/Cells .Formula / .FormulaR1C1 = "new formula"
For simplicity, if you post the range details someone might detail it if you need.
Last edited by Fazza; 10-10-06 at 05:03.