Great suggestion vletm and Peter! I am always looking at formulas and macros to get stuff done. Never crossed my mind to change the font. Sometimes the simplest solution is the easiest.
Thank you to all who replied. This can be closed now.
Thanks vletm. I thought it was something different. I need something that I can highlight a number of cells in a table in a template and make them capitalize. So when I type some text in these cells they will show as caps. I drag the template along to duplicate therefore the formula or code must...
Hi guys. I have a template 40 rows long and 12 cols wide and I would like a number of the cells in it to be capitalized so that when I fill it out the text in these cells show as capitals. I understand that this is difficult as Excel has not allowed for it but has anyone worked out a solution...
I really appreciate your help Hui and Narayan. Hui your formula worked. It has saved me a lot of time doing manual corrections for which I am thankful.
Narayan your suggestion helped but did not work in every case. My fault for not sending a file.
Thanks for your prompt reply as usual guys.
Mal
Hi, Nebu helped me with a formula two years ago which we use extensively. It puts surnames and first names in a configuration that I use to sort names in a data base. But it has always had a bug. For two years I corrected it manually but our database of names is now larger and requires many...
Thanks for the prompt reply Hui. I put that setting in, saved and closed Excel but it has had no change. In the attachment I have shown an email address I typed in a new excel worksheet and its resulting hyperlink settings. What is happening is the email address gets hyperlinked when I tab out...
Hi guys. I recently updated Office from 2010 to 2016. I use Win10 x64. For all customers we type in their address which includes their email address. All details are typed in individual cells. When we enter their email address it would previously (in Excel 2010) automatically create a hyperlink...
It all occurred after my CPU had a hernia Hui. It stopped and started several times and blue screened. I dismantled it and blew out the fluff. It has worked perfectly since. Strange coincidence. I use comments extensively and I do have a macro that sets the size of the comments. I need a box of...
Thanks Hui. Very helpful. It seems the font in my new comment boxes has defaulted back to the original text today. Must have been a MS update overnight that repaired it I guess. Your macro will be helpful to fix the existing ones which now remain with that problem.
Appreciate your help
MalR
Hi guys. My CPU failed, did several stop/starts. I use hundreds of comment boxes in an excel spreadsheet. It changed the text in all the comment boxes to a strange font. I understand comments can be formatted individually in Excel but to change the default setting it must be done in Windows. In...
Thank you for your effort in this. I realize it was not easy. Also thanks for a clear explanation. This macro will speed up my processing. I had to count the cells individually before I had this. There will be no coloured hatchings.
I tested it and it works nicely.
Much appreciated!
Can you do hashed with colour to mean occupied
Hashed without colour to mean unoccupied. In both cases there will be text and possibly a comment box in them.
In the program a colour (with or without a hash) means someone has paid for the room (it is occupied) and an uncoloured cell with hash...
Thanks. There should have been a hatch in the original file. The hatch warns us of certain things. There are not many hatches used and I can use an alternative method of highlighting if it helps. That might be easiest.
You have been most helpful and I had no idea what the macro was doing and how...