Now that I re-read this, it doesn't appear clear from my previous post that I
activated the row in my macro. Just for the sake of completeness, the line I
added was:

wsTracking.Cells(lTrackStartRow, iTrackStartCol).Activate

Also I just now noticed a typo. I fixed it now but in the sentence that
said in three subsequent tests I didn't include the words it worked.

--
Kevin Vaughn


"Kevin Vaughn" wrote:

Thanks. I'll read that. In the meantime I did come up with what appears to
be a workable solution. I tried it this morning and it worked in three subsequent
tests. I don't know if it is what John's site discusses but I activated a
cell that was in the correct row and my CF is correct.
--
Kevin Vaughn


"Jim Cone" wrote:

Kevin,

John Walkenbach has something to say on the subject here...
http://j-walk.com/ss/excel/odd/odd07.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware