Code for Indent if criteria is true

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

FAQ

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 »

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 06:13 AM.