they definetly do work. The HTML is much more complex so i decided to
try this and it worked. I inserted a new workbook and broke the HTML
up in four cells so the cells read like this on the new worksheet named
Code:
I did rename my sheets and what I'm searching for to protect identity
if it looks strange.

B1:=LEFT(CurrentProject!S3798,FIND("Product
Name",CurrentProject!S3798)-1)
B2:=MID(CurrentProject!S3798,FIND("Model#",Current Project!S3798)+8,506)
B3:=MID(CurrentProject!S3798,FIND("Max
Size",CurrentProject!S3798)+1,202)
B4:=RIGHT(CurrentProject!S3798,32)

in the cell that i need the info to go into the code reads like this
S3851:=Code!$B$1&C3851&Code!$B$2&Q3851&Code!$B$3&R 3851&Code!$B$4

If anyone needs explanation on how these work i'd be obliged to help as
this community has helped me out tremendously.


--
Chuck N
------------------------------------------------------------------------
Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057
View this thread: http://www.excelforum.com/showthread...hreadid=536825