MrExcel Publishing
Your One Stop for Excel Tips & Solutions

More help please dave


Posted by Jimmy on January 10, 2001 5:18 AM

When I run this macro I get the message box about the "Supervisor comments already exsist" even if the comment box is empty. I suspect it is because if cell A83 which contains the heading "SUPERVISOR COMMENTS" then the range of cells which actually contains the comments are A84 - I93 (merged cells). I worked past this part of the code (just marked them as comments, so I could check the rest of the code) and then get error messages in the part of the code which copies and paste into the new sheet (A83 and supcomments). The error says something to the effect "Cannot change part of a merged cell". Sorry it is all proabably something real simple, but I can't seem to figure it out. Thanks for any more help you can give me

My code and the code you helpl me with is at
7855.html


Posted by Dave Hawley on January 10, 2001 5:29 AM


Hi Jimmy

Sorry Jimmy, didn't realise, time difference hazard.

I'll get onto it in 12 or so hours (10:00pm here).

Dave

  • OzGrid Business Applications

Posted by Dave Hawley on January 10, 2001 6:26 PM


Hi Jimmy


Ok, the "Supervisor Comments already exists" message you get is an error message I put into the code to let you know that there is already a Worsheet called "Supervisor Comments". You cannot have 2 worksheets with the same name.


Basically the code is set up to run once in a workbook that DOES NOT contain a Sheet called "Supervisor Comments" which already has the merge cells A2:I40.

Run the code in a workbook that has a Sheet called
"Eval Form", a named range on this sheet called "SupComments" and any data in cell A84 of the same sheet. Then you will see what is does. But remember to run it a second time you will need to delete the sheet "Supervisor Comments".

See if that helps


  • OzGrid Business Applications

Posted by Jimmy on January 11, 2001 1:54 PM

Dave I am getting the Error Box "Supervisor Comments already exist" before it makes the sheet called "Supervisor Comments". There is not a sheet in the workbook called this only one called Cover Sheet and one called Eval Form. I appreciate all the help, but can't figure this thing out.

Thanks

Posted by Dave on January 11, 2001 9:12 PM

Thanks


Put the code: On Error GoTo 0
directly below the line that creates the sheet "Supervisors Comments" Excel will then give a Runtime error that will lead you to the problem code, I suspect it has something to do with pasting over a merged cell.

Dave


  • OzGrid Business Applications

Posted by Jimmy on January 12, 2001 6:30 AM

Thanks Dave, but one last question.


Dave thanks, for all your help. I figured it something I am doing. When I placed the code in a new workbook it works fine, but when I put it in the workbook, that I presentley have it gives me problems, but I think now I can work around it. Thanks for all you help.

I do have one more question though. Does excel limit the number of line or characters that can be placed in a cell? Or in merged cells. Say I have the merges cells A1:I40, will excel limit the characters placed into these cells and only print the max amount allowed.

Posted by Dave Hawley on January 14, 2001 8:42 PM

Re: Thanks Dave, but one last question.

Put the code: On Error GoTo 0 directly below the line that creates the sheet "Supervisors Comments" Excel will then give a Runtime error that will lead you to the problem code, I suspect it has something to do with pasting over a merged cell. : Dave

Hi Jimmy

The maximum characters allowed in a cell is 32,000.


  • OzGrid Business Applications