What are you trying to do? The syntax of using For in that code looks totally wrong. If you want to set an array formula, then use
Range("B4").FormulaArray = "formula"
What are you trying to do? The syntax of using For in that code looks totally wrong. If you want to set an array formula, then use
Range("B4").FormulaArray = "formula"
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote