referencing several cells in a worksheet header

[liz5818]

I need to be able to link several cells to create a header. I have a code started, but what i need is this format as the header for sheet1:
First line: Sheet2!b5 (Sheet2!b3)
Second line: Sheet2!b4, Sheet2!b2

Please Login or Register  to view this content.

I can't figure out how to get the other 3 cells to work in the code.

[liz5818]

bump no response

[liz5818]

bump again. still no response.

[liz5818]

bump. Still no Response.

[liz5818]

bump once again. no response.

[redsab]

liz,
I am not real proficient at VBA, but this code will work. I have included the workbook. Be sure when you do your ctrl + h that you are in sheet1! Hope this helps!

redsab

[liz5818]

thanks redsab. Better than what i've gotten in the past month. gonna check it out now. thanks for your help. extremely appreciated.

[liz5818]

code included in mod.

Please Login or Register  to view this content.

pasted into sheet 1

Please Login or Register  to view this content.