Hi, all<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o> Is any vba that can adjust column with according text entered.<o></o> <o></o> Thankx<o></o> Moti<o></o>
the above would adjust column B to fit the text within.
Always worth remembering that for tasks like this the macro recorder will normally show you how to achieve your goal -> ie press record, do what you want to do manually, stop recording -- review the resulting code. This will often give you what you need for a trivial task and if not it will most likely point you in the right direction.
Hello, lasw10<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o> <o></o> Really I need some Private Sub function I think that allow to fit automatically as you write text long or short.<o></o> But in the macro I have to run to get Result.<o></o> <o></o> Thanks Moti
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.