Adding text strings after last populated row of a worksheet

[chadski778]

I have 3 statements (text strings) to add at the end of the last row of data in column A on my spreadsheet. How can I automatically add the following:

"statement 1" - 3 rows below last populated row on worksheet (format - calibri, font size 13)
"statement 2" - 5 rows below last populated row on worksheet (format - calibri, font size 13)
"statement 3" - 7 rows below last populated row on worksheet (format - calibri, font size 14)

see example below

Excel Workbook
	A	B	C	D	E	F
1	BEFORE
2
3	Substance
4	Highly refined mineral oil (IP346
5	Highly refined mineral oil (IP346
6	Highly refined mineral oil (IP346
7	Highly refined mineral oil (IP346
8	Highly refined mineral oil (IP346
9	Polyolefin polyamine succinimide polyol
10	Calcium alkaryl sulphonate
11	Zinc dialkyldithiophosphate
12	Olefin co-polymer
13	Highly refined mineral oil (IP346
14	Polyalkylmethacrylate
15	Calcium alkaryl sulphonate
16	Borated polyolefin polyamine succinimide
17	Polyolefin polyamine succinimide molybdenum cmplx
18	Polyalkarylamine
19	Branched alkanes
20	Alkyl methacrylate (as impurity)
21
22
23
24	Risk Phrase Key:
25	N/C = Not classified as hazardous under EC Directives
26	R36/37/38 = Irritating to eyes, respiratory system and skin
27	R38 = Irritating to skin
28	R41 = Risk of serious damage to eyes
29	R43 = May cause sensitisation by skin contact
30	R50/53 = Very toxic to aquatic organisms, may cause long-term adverse effects in the aquatic environment
31	R51/53 = Toxic to aquatic organisms, may cause long-term adverse effects in the aquatic environment
32	R53 = May cause long-term adverse effects in the aquatic environment
33	R65 = Harmful: may cause lung damage if swallowed
34
CasDoc

Excel Workbook
	A	B	C	D	E	F
1	AFTER
2
3	Substance
4	Highly refined mineral oil (IP346
5	Highly refined mineral oil (IP346
6	Highly refined mineral oil (IP346
7	Highly refined mineral oil (IP346
8	Highly refined mineral oil (IP346
9	Polyolefin polyamine succinimide polyol
10	Calcium alkaryl sulphonate
11	Zinc dialkyldithiophosphate
12	Olefin co-polymer
13	Highly refined mineral oil (IP346
14	Polyalkylmethacrylate
15	Calcium alkaryl sulphonate
16	Borated polyolefin polyamine succinimide
17	Polyolefin polyamine succinimide molybdenum cmplx
18	Polyalkarylamine
19	Branched alkanes
20	Alkyl methacrylate (as impurity)
21
22
23
24	Risk Phrase Key:
25	N/C = Not classified as hazardous under EC Directives
26	R36/37/38 = Irritating to eyes, respiratory system and skin
27	R38 = Irritating to skin
28	R41 = Risk of serious damage to eyes
29	R43 = May cause sensitisation by skin contact
30	R50/53 = Very toxic to aquatic organisms, may cause long-term adverse effects in the aquatic environment
31	R51/53 = Toxic to aquatic organisms, may cause long-term adverse effects in the aquatic environment
32	R53 = May cause long-term adverse effects in the aquatic environment
33	R65 = Harmful: may cause lung damage if swallowed
34
35
36
37	This product is toxic to aquatic animals
38
39	This product is corrosive
40
41	This product is classified R34 according to EU criteria
42
43
CasDoc (2)

Thanks

 

[Joe4]

Is it safe to assume that you question was answered here?
http://www.mrexcel.com/forum/showthread.php?t=571426