VBA to autofit merged rows

Joined
Aug 30, 2012
Messages
13
Reaction score
0
I have been searching online and I keep finding that it some cases, it works, in others it is not recommended. :blush:

I have a spreadsheet with many different information that requires specific row size but I have one row where the information could exceed its given space....where the autofit is needed.

I have tried many VBAs but none really worked. I am still new to this, though I love to learn more and eventually understand what the codes actually mean. :cry:

Am I dreaming too big or can this actually be done? :confused:

Thanks.:bow:
 
Joined
Aug 30, 2012
Messages
13
Reaction score
0
That doesn't work. After much searching, it says I need to use VBA but its quite complex. I tried several online but none seem to work (despite the changes I needed to make).

I know about VBA but, I'm no programmer. :(
 
Joined
Apr 6, 2006
Messages
40
Reaction score
1
Johfra,

Here's the code to auto fit an entire column, in this example column A, but I don't think excel will let you autofit a merged cell, or a single cell for that matter.

Columns("A:A").EntireColumn.AutoFit


.............But, if I understand what you want to do, I think this will work. Just leave out the merging.


Note: A great way to learn code and what it does is to use the record macro feature built into excel, located under the "tools" menu.

Go to tools --> macro --> record new macro

Once you change any of the options in the resulting window, if desired, and click "OK", Excel will record every action, in VBA code, you perform, like resizing columns, until you click the stop square within the macro window that pops up when you start recording.

After you stop recording, go to tools --> macro --> visual basic editor to view the code Excel recorded and select the workbook and module of the macro you recorded.

After you feel comfortable with VBA basics, there is even an option to record with relative referencing, by reference from a particular point instead of directly.

This option is located on the macro window right next to the "stop recording" button.

Happy programming,
Smithb2
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top