I'm almost a total novice at macros. I have some understanding of the "logic" behind macros, but limited experience.



What I want to do is write a macro where the number in cell A1 will cause the data in B1 to indent based on that number. I assume the macro would go in B1 and look something like: =IF(A1=1)then (B1=0).

Example: if I put the number 1 in A1, I want the data in B1 to stay at 0.
If I put the number 2 in A1, then I want the data in B1 to indent 1 space.

Now comes the tricky part. I want the macro to cover 6 indentations. If A1 =3, then indent 2 spaces. If A1=4, then indent 3 spaces, etc.

Hope that makes sense.

Thanks,
Mickey