finding blank cells in a row in Excel 97

[Paul Herzig]

Hi,

I previously placed a post [july 30] asking how to use
goalseek in xcel 97. I have since learned that what I did
is OK. The problem is that, as near as I can tell, the
SpecialCells method is not supported in Xcel 97. ie:

Set Link_bud_cols = _
Range("C118:AP118").SpecialCells(xlCellTypeFormulas)

this works ok in xcel 2000 but not xcel 97


This was not obvious to me in my original debugging. The
debugger was pointing to the goalseek line, but the problem
occurred earlier when the list of occupied cells was being
built with the SpecialCells method. SpecialCells is
available in xcel 2000, but not so in xcel 97. So my
original assessment was incorrect.

So, my problem now is how to build a list of cells in a row
that are not blank. SpecialCells did this rather nicely.
How do I accomplish the same in excel 97 ?

Thanks for any help,

Paul

 

[Greg Griffiths]

You are going to have loop through all the cells and test their value I
think.

 

[Sandy V]

The SpecialCells method is certainly available in my Excel
97 and your example works fine for me (xl97).

Regards,
Sandy