Hi Richard Welcome to the forum. I think you will need to clean your data first. There are many cells within your data range that looks like bla...
Hi Alan See if this help. Sunny
Hi Maurizio Yes, I know you will need to set Application.EnableEvents=False but I was trying to convince you not to use the Worksheet Events as the...
Hi Maurizio I did not say I wanted to see your data. I just wanted to know what you want to achieve. I was asking why you use a worksheet event ...
Hi Maurizio I would have added a button on the sheet instead of asking user to select the cell. Anyway you can try this code. It checks which ce...
Hi Vic Did you try and create your own file using my codes? Does it give you problem?
You are welcome.
You are welcome. Sunny
Hi Vic I have viewed the video numerous times but still unable to spot the cause. My first impression was it could be caused by grouping of the ...
Hi See if this helps. If the amount is 10.00 (without cents, for example) then it will show Ten Only without the Cents. Sunny
Hi Shawn You mentioned thousands of rows but did not mention how many columns. If you don't have too many columns then I suggest adding some hel...
Ahhh a brilliant idea Philip!!!! Now everyone can see the problem and chip in with their solutions.
Hi Vic Did you try my latest attachment hat I did from scratch? I believe it is against the Forum policy to contact me personally but you may ne...
Hi Hannes When requesting for a macro solution it is best if you can supply the actual file (you can change the values if it contain sensitive info...
Hi Vic Attached is the template with no data. I suggest you test with the empty template first before adding any data to see if the problem is h...