Finding and selecting specific text in a worksheet

[chadski778]

I would like code for finding specific text in my worksheet, selecting it and also selecting all the data in the rows below until the first empty is found. Example below:

Excel Workbook
	F	G	H	I
33	Actual%	Generic Name	EC Hazard	CAS Number
34	74.92	Highly refined mineral oil (IP346	N/C	Various
35	74.92	Highly refined mineral oil (IP346	N/C	64742-62-7
36	74.92	Highly refined mineral oil (IP346	N/C	64742-65-0
37	10	Highly refined mineral oil (IP346	N/C	64742-54-7 or 92062-09-4
38	5.852	Highly refined mineral oil (IP346	N/C	64742-65-0 or 64741-88-4 or 64741-89-5 or 72623-86-0
39	3.99	Polyolefin polyamine succinimide polyol	R53	Polymer
40	1.064	Calcium alkaryl sulphonate	R53	Not available
41	1.064	Zinc dialkyldithiophosphate	R41-51/53	68649-42-3
42	1.06	Olefin co-polymer	N/C	Confidential
43	0.99	Highly refined mineral oil (IP346	N/C	Not available
44	0.99	Polyalkylmethacrylate	N/C	Not available
45	0.931	Calcium alkaryl sulphonate	R43-53	Not available
46	0.399	Borated polyolefin polyamine succinimide	R53	Not available
47	0.133	Polyolefin polyamine succinimide molybdenum cmplx	N/C	Polymer
48	0.0532	Polyalkarylamine	R51/53	68411-46-1
49	0.0266	Branched alkanes	R38-65-51/53	Polymer
50	0.01	Alkyl methacrylate (as impurity)	R36/37/38-50/53	142-90-5
Composition

In effect, the macro will find and select "Actual%", "Generic Name", "EC Hazard" and "CAS Number", which are in columns F, G, H and I, and the data in the rows below the headings in the same columns. Effectively, it is like selecting a table of data

 

[chadski778]

Sorry that should have said selecting the data until the last empty row is found.