Excel Set Range Format

[Neib74656]

Hello Everyone,

I am trying to get MS to set a range in Excel to Text format. I have gone through the Excel documentation as suggested in the manual but no luck.

Specific bit of code I am using is the below but I can not figure out what the format part of this should be

XLSetRangeFormat>XY,Sheet1,B2:B10000,

Thanks for any help you can provide.

[Dorian (MJT support)]

I wasn't too sure either, so I recorded an Excel macro to format text and looked to see what it created.

This was the result :

Code: Select all

Sub Macro1()
'
' Macro1 Macro
'

'
    Range("D3:E6").Select
    Selection.NumberFormat = "@"
End Sub

So :

Code: Select all

XLSetRangeFormat>xlh,FormatTest,B2:B10000,@

[Neib74656]

This worked perfectly thanks very much!