Hi there,
The range specified (1:6970) is not a valid range, unless you're referring to the entire rows from row 1 to row 6970, which houses (in versions 97-2003) 256 columns for each row, equalling 6970 * 256 = 1784320 cells total.
Can you explain more about what you are wanting to do? Maybe tell us any criteria or what the intended purpose of this is?