|
|
#12
04-06-2021, 12:08 AM
|
|||
|
|||
I would run an update macro if you have existing data to indent, just the range then run (in a normal module). Obviously this can be updated/improved
Code:
Sub IndentArrows()
Dim r As Range
Dim c As Range
Set r = Selection
For Each c In r
If Left(c.Value, 1) = ">" And c.IndentLevel = 0 Then c.InsertIndent 1
Next c
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date | trevorc | Excel Programming | 1 | 03-04-2021 02:39 PM |
 Formula to format "I" column based on if "F" column row is not blank
|
ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
| Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
| the character "v" when typed acts like ctrl-v. | jim redfield | Word | 1 | 09-22-2012 05:19 AM |
| Why the "decrease indent" doesn't affect the selected text to move???? | Jamal NUMAN | Word | 0 | 07-12-2011 04:10 PM |
Windows 10 
Office 2019
Threaded Mode