Search results

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...

Thanks vletm. Can you explain how <CAPS LOCK> is done please. It looks interesting.

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 but it won't allow you to remove the "mail to". It gets put in automatically

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...

p45cal could you look at this workbook please. Sometimes the macro will not work

OK. Thanks you gave me a greater understanding on macros. This is a great macro. I am going to file it as my "p45cal macro" along with my Narayan, Nebu and SirJB7 ones! Case closed now.

Great! I never would have found this solution. I will use this macro daily. One last thing. It displays 0.5 instead of 50%. I can format the cells in the worksheet that it displays in but is there any way in the body of the macro eg properties that I can set it? If so can you indicate the steps...

Thanks. Not sure exactly what you mean. I renamed the worksheet and the file. Is this any better?

Thanks for the quick reply p45cal. I just supplied a section of the worksheet and thought maybe you could add your code. In other words I give you the sheet and you code it up in case I was doing something incorrect. I have enclosed the same worksheet with the code in it now. It still produces...

Thanks very much for your help p45cal.

p45cal, I have pasted your code into a new module in my spread sheet. The clips in the file attached show the vba and they also show that when I call up "=Occupancy" and tell it what cells to calculate it returns #VALUE!. The code works in the spread sheet that you attached and I can run extra...

Thanks Whatever. You are a life saver! I spent hours manually reformatting. This proved to be an immediate fix. Merry Xmas! MalR

Hi guys. I notice some threads on other sites about this but none were helpful. I have a large file with many worksheets. There are lookups, macros, plus many other formulas in them but no pivot tables. I did the usual save last night and on opening today all my numbers had been reformatted to...