Gustav Brock
Gustav at cactus.dk
Wed Feb 1 11:26:06 CST 2006
Hi John That can be done. So your problem is solved? /gustav >>> jwcolby at ColbyConsulting.com 01-02-2006 18:02:30 >>> Gustav, Jim, Nope, what I was looking for was .Range(strRange).Interior.ColorIndex = rst!DS_ExcelColorIndex In this case at least, strRange can be in the form "B23", referencing column B, row 23.