![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Accidental automatic indent? | markg2 | Word | 8 | 12-10-2012 06:45 PM |
![]() |
markbh | Word | 3 | 07-16-2012 02:59 PM |
Indent Problem | adamsoa | Word | 1 | 05-07-2012 10:58 PM |
![]() |
lkatz1 | Word | 3 | 11-16-2011 12:01 AM |
Hanging Indent | bixby | Word | 0 | 07-22-2010 07:32 AM |