0
votes
1answer
3k views

Need an excel macro to produce a formatted text file

I am just learning how to make macros and I found a macro that nearly does what I need it to do, which is output a text file from Excel. What I need it to do is output this in a .mhd format, which I ...
2
votes
1answer
633 views

Macro for helping superscript last character of many rows in a single column

I'm adding footnotes (always adding footnotes) to a table and I would really like to be able to automate the repetitive nature of making my symbols superscript. Currently it’s: >enter cell>highlight ...
0
votes
1answer
690 views

Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...
0
votes
3answers
2k views

Excel VBA/Macro: how can I delete rows and remove dots & dashes?

I've recently been handed an Excel file to format - 100's of lines. The image below shows you the state of it. This could be a really long exercise if I work through it manually, so I wondered if a ...
4
votes
3answers
3k views

How can I get Visual Studio 2008 to align my assignment operators?

I had this in Vim and miss it dearly now that I'm confined to Visual Studio. I'd like to take this: MyType type_obj = new MyType(); MyLongerType longer_type_obj = new LongerType() To this: MyType ...