Thread: [Solved] Indent when ">" is typed in Column A
View Single Post
 
Old 04-05-2021, 09:41 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Ah okay. There are codes in the Module and Workbook in the first file that I copied. I deleted them and now it is perfect. I changed the InsertIndent 10 to 1. Thank you Purfleet.

Another please. When the tables are loaded to a power query, the indents are deleted in the process. What I do to return the indents in the resulting query table is by Find ">", Replace "five spaces >". Can the code above be changed to find the ">" then apply the indents?
Reply With Quote