Bobby Heid
bheid at appdevgrp.com
Thu Dec 30 06:54:41 CST 2004
Hi all,
I'm trying to format a small range of cells. I want to set the format on a
row-by-row basis. Basically, I am building a report from Access into an
Excel spreadsheet.
I am accessing the range like this
With .worksheets(1).Range(.worksheets(1).cells(l, 3),
.worksheets(1).cells(l, 5))
End With
Does anyone know what method(s)/properties I need to use to set the range's
number of decimals to display, as standard number, and as a percent? I am
currently looking for this information, but if anyone already knows, it
would greatly speed up my work.
Thanks,
Bobby