Attached is my Workbook.
Currently when checking the CheckBox (in A26), it will convert mm to inches in the range specified, but it will add 0's to blank cells. I want it not add anything if the cell is blank.
Thank you
Attached is my Workbook.
Currently when checking the CheckBox (in A26), it will convert mm to inches in the range specified, but it will add 0's to blank cells. I want it not add anything if the cell is blank.
Thank you
Try this:
![]()
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
![]()
Please Login or Register to view this content.
TMS unfortunately it just gave me FALSE when I tried your code. But thank you for trying.
jolivanes yours worked perfectly! Thank you so much!
Both of your help is much appreciated.
Thank you for the come back and good luck.
Ah, not sure why that is. It worked ok for me with your sample file. Ho hum, at least you have a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks