Hello all,

Given below is a line that gives me constant error.
Set rng1 = rng.SpecialCells(xlConstants)
where rng
is Set rng = c(1, 2).Resize(1, 255)
Error was: No cells were found.

Later, I found that , though the cells had numbers, the numbers in the
cell were the resultant of forumla. I guess that is the reason for the
error. for example if E6 = 1; it is a resultant of E6 =
MMULT('AAA'!B2:BV74,'BBB'!B2:BV74); where AAA and BBB are sheet names.
All the cells in the range=rng are governed by formula

I tried Set rng1 = rng.SpecialCells(xlConstants, xlTextValues) also.
Still the error persists. How to tweak the line such that the value
alone is read and NOT the formula governing it.

Any help in this issue will be greatly appreciated.

Thanks,
Thulasiram