Just copy the formula text and paste it with transpose form and you will u'standthe problem.And I wan solution in the VBA coding form ie in Macro coded form.