Change the number of spaces for indent

[craig.penny]

How can I change the width of an IndentLevel? I've searched on the web and all I can find is how to change the IndentLevel i.e. Cells(1,1).IndentLevel = 1 or Cells(1,1).IndentLevel = 2 which isn't what I'm after. What I want to do is have any given IndentLevel have a larger apparent size.

Any help is appreciated!

 

[craig.penny]

Anyone?

 

[shg]

I don't believe it's possible.

 

[craig.penny]

Darn it...

Well thanks for replying!

 

[Norie]

Craig

I don't know if it's really an option but you can use InsertIndent to set the indent to whatever you want.

Cells(1,1).InsertIndent 6

 

[craig.penny]

Thanks Norie. I will file that one away. It doesn't get at what I was trying to do but I bet it'll come in handy someday.

I could swear I adjusted the width of an indent once upon a time but I'm probably just remembering doing it on an application I use at work that's very similar to Excel.

I've always been curious why you use that icon. Do you have a bird like that?