All Questions
7
questions
1
vote
0
answers
237
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
- 11
0
votes
1
answer
81
views
Excel 2013 fails to record macro correctly
So, i want to create a macro that will set selected cells' format to 0,0 ¥.
However, if you record the steps and then try to run the macro it will set format to 0,0 ?. Is there a way to fix this?
- 11
0
votes
1
answer
477
views
How to FIX a RAND-BETWEEN Alternative Macro in Excel
I am looking for a RandBetween Altermative that has the exact same function but remains constant. I was looking for a macro that woould do just that and I thought I found one...
Function RndInt(...
0
votes
0
answers
87
views
Formatting similar MSWord (pasted from MSExcel) tables in batch
I've got a lot of similar spreadsheets (same dimensions, different numbers) in Microsoft Excel, like this:
To present them in my report in Microsoft Word, I have to format them in this way:
To ...
- 111
3
votes
2
answers
112
views
How to format text between branches excel using a macro Excel 2010
I found a little macro to change all the text between "[" and "]" red in excel.
But i can't get it to work in Excel 2010, i get some errors.
Can someone help me debug this?
At the end i wish that in ...
- 61
0
votes
1
answer
7k
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 ...
- 101
2
votes
1
answer
2k
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 ...
- 1,538