PDA

View Full Version : Solved: Format Cell Question



CreganTur
02-24-2009, 07:16 AM
Search isn't working here... google has failed me... so I'll go ahead and post this, even though I know this has already been answered somewhere else. I just wish I could find it!

I'm using "ActiveWorkbook.Worksheets.Add , ActiveSheet" to create a new worksheet(Sheet2), and then I'm moving some data from Sheet1 to the newly created Sheet2. I just need to know how to set the cell formatting to Text on Sheet2- I've got some numbers that have to have text formatting because this process prepares an Excel report's data so it can be Mail Merged into a form letter.

Thanks:thumb

Bob Phillips
02-24-2009, 07:28 AM
myrange.NumberFormat = "@"