if cell has indent, do x

**ammartino44** · 03-24-2015, 01:23 PM

Can someone show me different ways I can write a code like this? If cell is indented right, do this? Is there also a way to do this without vba?

**Mad-Mizer** · 03-24-2015, 01:27 PM

I quickly made the following:

Please Login or Register  to view this content.

Adapt it how you need to.

**ammartino44** · 03-24-2015, 01:28 PM

Actually, I think I figured it out. I'm a genius!! Any suggestions for improving this code? Different ways to approach? Thanks.

Please Login or Register  to view this content.

**ammartino44** · 03-24-2015, 01:33 PM

How would I modify that code, to loop through all cells in a range?

**ammartino44** · 03-24-2015, 01:40 PM

I tried this but it didn't work. Why?

Please Login or Register  to view this content.

**Mad-Mizer** · 03-24-2015, 02:17 PM

I'm not sure why that didn't work but the following does:

Please Login or Register  to view this content.

Re: if cell has indent, do x