Hi everybody,

I have a procedure that creates Excel from DBF and applies some custom formatting. Everything is fine except when I open the Excel, it comes selected.

I assume this code is responsible for this:

		with loSheet.range(m.lcRange).Interior
			.ColorIndex = 33 && Blue Color
			.pattern = xlSolid
			.PatternColorIndex = xlAutomatic
		endwith
	endif
	
** Made the Totals row in bold and Green highlight
	loExcel.range([A1], loExcel.selection.SpecialCells(xlLastCell)).select
	loExcel.selection.FormatConditions.delete
	loExcel.selection.FormatConditions.add(xlExpression,, '=UPPER(Left($A1,5))="TOTAL"')

	with loExcel.selection.FormatConditions(1)
		.font.Bold = .t.
		.Interior.ColorIndex = 4
	endwith

My question is, how should I unselect everything before saving, e.g. nothing should be selected?

Thanks in advance.