Trying to set cell data type to text or general in vba -- using:
ObjExcel.ActiveSheet.Columns("C").NumberFormat = "General"
but still makes a number defined column of cells
is there a another way
thanks
Pete
Hi
I want to run a spell check on 3 specific columns in a table. I've got the 'DoCmd.RunCommand acCmdSpelling' to start the spell checker, but need to select these columns prior to running this command. How would I select these columns in VBA so the user doesnt have to. I cant find a lot of...
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.