Macro Runtime error 1004 on IndentLevel

[Jacolene]

I have a Macro running to change the indent levels as per below and getting "Runtime error 1004 - Unable to set IndentLevel property of the Range class"

Please Login or Register  to view this content.

I know that I am getting the error because there is only data until B156, if I change the Macro to run from ("B10:B156"), I don't get the error.

As other people will be working with the spreadsheet and might add additional data, I decided to give them some space to maneuver.

How can I keep the current macro ("B10:B250") running, without the error?

[mehmetcik]

Please Login or Register  to view this content.

[davesexcel]

Do a len() count of the cell.

Please Login or Register  to view this content.

[Jacolene]

Thank you both mehmetcik and davesexcel! Really appreciate it!