All Questions
4
questions with no upvoted or accepted answers
1
vote
0
answers
250
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
479
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