Help with if then statements

macropod · #30 07-21-2015, 04:45 AM

Quote:

Originally Posted by brent chadwick

1) I need to take out the 1890 as there is no census for that decade.

the simplest solution for that is to change:
.Add Name:=i
to:
If i <> 1890 Then .Add Name:=i

Quote:

Originally Posted by brent chadwick

2) When I create a toolbar for this doc both of the macros do not show up in the commands section. Why is that?

Are you adding the macros to your template and creating the 'toolbar' in that? Note, too, that the document I returned references Word's Normal template, not the template attached to post #30.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple If statements,	Jamal NUMAN	Excel	16	11-15-2022 11:59 PM
Countif statements	Alaska1	Excel	5	02-05-2015 07:55 PM
Using IF statements	stuwoolf	Excel	2	01-10-2015 01:58 PM
count if statements	Alaska1	Excel	1	05-14-2014 08:21 AM
IF statements that shifts to right.	kent	Excel	0	01-19-2006 02:23 PM