Excel HTML Maker

[DeusXv]

Just wondering have any of ye had issues using this before, I posted the below into the test forum and it worked perfectly, but tried posting it in another thread and it just posted the HTML code and not the actual data.

anyone else experience this ?

Excel 2007
	A	B	C	D	E	F	G	H	I	J
1	Words		Range		Duration		Total Duration			Cell Address of Answers
2	2105		300-699	300	50		147350			$G$2
3	1330		700-2099	700	60		79800			$G$3
4	3618		2100-3199	2100	70		289440			$G$4
5	5150		3200-4999	3200	80		463500			$G$5
6			>5000	5000	90
Sheet1

Cell Formulas
Range	Formula
G2	=LOOKUP($A2,$D$2:$D$6,$E$2:$E$6)*A2
G3	=LOOKUP($A3,$D$2:$D$6,$E$2:$E$6)*A3
G4	=LOOKUP($A4,$D$2:$D$6,$E$2:$E$6)*A4
G5	=LOOKUP($A5,$D$2:$D$6,$E$2:$E$6)*A5
J2	{=CELL("address",INDEX($G$2:$G$5,MATCH(G2,$G$2:$G$5,0)))}
J3	{=CELL("address",INDEX($G$2:$G$5,MATCH(G3,$G$2:$G$5,0)))}
J4	{=CELL("address",INDEX($G$2:$G$5,MATCH(G4,$G$2:$G$5,0)))}
J5	{=CELL("address",INDEX($G$2:$G$5,MATCH(G5,$G$2:$G$5,0)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[DeusXv]

As you can see the above is all messed up, however prior to the thread being moved it was perfect. I also posted the same in a test thread and it comes out perfectly.

Here is a link to the test thread:

http://www.mrexcel.com/forum/test-here/722548-test-delete.html

 

[Joe4]

Which Forum are you trying to post it to that it is not working (note that HTML code is not enabled for all of the Forums)?

 

[DeusXv]

Which Forum are you trying to post it to that it is not working (note that HTML code is not enabled for all of the Forums)?

It was in the "about this board"

But now knowing what you said makes perfect sense as this thread was originally in Lounge and it worked, but when it was moved here, it didn't so problem solved.