I'm using Excel 2010. Interested in obtaining which columns in a row are populated with information and then storing it to a variable. How would I go about getting this?
TIA,
Tim
Thanks for the quick reply Skip. I have formatted the cell to MM:SS@ hoping for time display 10:12 example. Unfortunately, when I enter 25:12 as an example, Excel will convert to 12:00.
Thanks.
Hi All,
I am looking to format a column for time i.e. minutes:seconds.
I've tried custom formatting etc. no luck.
Any help would be appreciated.
Thanks.
Hi All,
Attempting to change a control's backcolor via a variable. Calling sub changeBackColors and setting strControlName to current control. Problem is when I attempt to execute Me!strControlName.BackColor = vbYellow, I get a syntax error. I know my syntax at Me!strControlName is wrong...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.