Code for Indent if criteria is true

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Code for Indent if criteria is true

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-19-2020, 09:03 PM

Logit

Windows 10 Code for Indent if criteria is true

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

.
This macro will do what you are seeking :

Code:

Option Explicit

Sub IndentB()
Dim i As Range

For Each i In Sheets("Sheet1").Range("E4:E15")
    If i.Value > 0 Then
        i.Offset(0, -3).InsertIndent 2 ' Offset selection from column E
    End If
Next i

End Sub

Attached Files

Indent Cell Text Based On Other Cell Value.xlsm (15.3 KB, 11 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Difference between first line Indent and Left Indent	kingston123	Word	3	09-25-2018 02:47 PM
How to modify code for Auto filter based on two criteria ...	LearnerExcel	Excel Programming	13	02-14-2018 08:20 PM
Issue of 2 fixed bullet points indent setting work together (code included)	puff	Word VBA	5	12-17-2017 05:52 PM
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Find criteria, then paste- code is overwriting data	ufopilot	Excel Programming	0	02-18-2016 10:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.