| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set the IntendLevel using XLLFunctions (Macro Sheet - XLM)
Is there a way to set the Intend Level using XLM funciton. I found that
there is ALIGNMENT MacroSheet Function but it not possible to define the Intend Level? Any Help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set the IntendLevel using XLLFunctions (Macro Sheet - XLM)
You could use "Format.Number" ... '-- Dim strFormat As String 'Indent width of two spaces strFormat = "_ _ @" Application.ExecuteExcel4Macro ("Format.Number(""" & strFormat & """)") '-- Jim Cone Portland, Oregon USA "Raja" wrote in message Is there a way to set the Intend Level using XLM funciton. I found that there is ALIGNMENT MacroSheet Function but it not possible to define the Intend Level? Any Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming | |||
| Q: Creating a macro to sort and group columns in a sheet according to another sheet | Excel Programming | |||
| Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Hybrid Mode
