hi , i am popualte the data from MS access To Excel Using VBA during the population excel sheet it automatically set random width for thier cells. it is possible to set width equally for all cells using VBA thanks in advance
Thank you but i wants to set the equal space for all the cells in the sheet i got the answer ActiveSheetname.Columns.ColumnWidth = 12
raam
2010-06-01 09:53:28
This works exactly the same. "Cells" reflects all the cells in the worksheet. And I believe you meant ActiveSheet not ActiveSheetname
Cornelius
2010-06-01 10:15:45