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