>hi all,
>I am trying to tidy up an excel export program that i have. it all works ok but they layout needs a couple of tweeks. i am tryng to autoformat a cell but using the code below i get the error "... because you selected only one cell and the surrounding cells are blank, MS excel cannot determine which cells to apply the autoformat to"
>
>OleApp.Cells(lnCounter,1).AutoFormat()
>
>~M
Mark
I'm no expert at this but I recently did some formatting, with Boris's help. Would something like:
With OleApp
.Range("A2:A2").Select
.Selection.Autoformat
EndWith
work?
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.