Its a huge formula
iam trying to take cells in specific sheet to maser sheet.
can anyone please fix the formula by using specific sheet and range,there are 4 more sheets,i need to consider different ranges in different sheets. thats y iam trying to use this formula.
iam trying to take cells in specific sheet to maser sheet.
can anyone please fix the formula by using specific sheet and range,there are 4 more sheets,i need to consider different ranges in different sheets. thats y iam trying to use this formula.
Code:
MyFormulas = [COLOR=#800000]sheets(Array("Box Girder") range(Quantity1 )"[/COLOR]='" & wks.Name & "'!$T$105", "", "", "", "='" & wks.Name & "'!$T$109", "", "", "", "='" & wks.Name & "'!$T$124", "='" & wks.Name & "'!$T$143", "", "", "", "", "", "='" & wks.Name & "'!$T$115+'" & wks.Name & "'!$T$116", "", "='" & wks.Name & "'!$T$211", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "='" & wks.Name & "'!$T$151", "", "='" & wks.Name & "'!$T$157", "", "", "", "", "", "", "", "='" & wks.Name & "'!$T$167", "", "='" & wks.Name & "'!$T$169", "='" & wks.Name & "'!$T$168", "='" & wks.Name & "'!$T$160", "", "", "='" & wks.Name & "'!$T$183", "='" & wks.Name & "'!$T$193", "", "", "='" & wks.Name & "'!$T$187", "", "", "", "", "='" & wks.Name & "'!$T$192", "", "", "", "='" & wks.Name & "'!$T$158", "='" & wks.Name & "'!$T$159", "='" & wks.Name & "'!$T$200", "='" & wks.Name & "'!$T$195", "", "", "", "='" & wks.Name & "'!$T$203", "", "", "", "", "" _
& "='" & wks.Name & "'!$T$196", "", "", "", "='" & wks.Name & "'!$T$199", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "='" & wks.Name & "'!$T$212*25", "='", "='")
.Range("A10").Offset(, X - 1).Resize(119, 1).Formula = Application.Transpose(MyFormulas)