|
How can I create a macro in MS excel to find duplicates in a spreadsheet and highlight it
Started by at on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Microsoft explain how to do really need a macro, the easiest way would be to record the steps described above, then edit.
You can just use conditional formatting.
You don't need a VBA macro.
|
|
Hi,
I am creating nested macros in BOO, I wrote this program:
macro text: macro subMacro: text["Text"] = "Hello World" return [| block: System.Console.WriteLine( "Hello World" ); |]
But I am getting the error "Unknown Identifer: ' text '" in the 3rd line...
Started by Neo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If your macro is in a namespace named foo for example, you will need to add
import section like this:
import Boo.Lang.Compiler....
The error you are getting is likely to do with a missing import in the code where the macro is being called from.
|
|
I need to create a macro or VS.net Addin that will insert the current date and time and user name in a field in a TFS work item.
The sample macro does not work and I cannot find any way to programaticaly access a TFS work item that is open in the IDE....
Started by Gary on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Not sure it would be accessible from a macro -- might have to write a VS add-in as well.
|
Ask your Facebook Friends
|
I want to make a macro which will inject some code, like:
if (foo) { [Bar fooBar]; }
and then, where ever I need that, I put FOOBAR in the code. Not sure, but at compile time then the compiler replaces this with the actual code like in the example above...
Started by HelloMoon on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
However, be....
Unfortunately the macro will expand of the macro.
You can define a macro on multiple lines by adding a \ to the end of each line except the last.
That into a function, and then all you have to do is call the function .
|
|
How can I create a macro for getting the library name a class is compiled into? Is there some way of getting this information from make?
Essentially I'd like to do something like:
# define LIBRARY_NAME (get info from make maybe?) ... # ifdef LIBRARY_NAME...
Started by xeon on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This is equivalent to having
#define MACRO_NAME MACRO_VALUE
at the top of each file....
Presumably other compilers have similar features.
G++ allows you to use -DMACRO_NAME=MACRO_VALUE to supply macro values on the command line.
|
|
Is there a macro or little appliaction that allows our secretary to print a new phone list, but the data should come from active directory?
Answer Snippets (Read the full thread at serverfault):
You can use this to output ....
See a guide which will get you started here
Theres a good article on how to do so with a batch file here .
This is fairly straightforward once you have the LDAP query you need to pull the information from Active Directory .
|
|
I've got two spreadsheets ("Old" and "New") and a VB Script macro. The macro runs in one ("New"), does a comparison of the contents of the other ("Old"), and then outputs the results back on to the "New" spreadsheet.
I'd like to build an executable where...
Started by Bob. on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
create_macro_at_runtime_in_dotnet.asp http://support.microsoft.com/kb/306683 Why not just create on the File Dialog, but it should allow you to create a button on 1 file and run the comparison to your macro in ThisWorkbook....
|
|
I'm trying to write a macro in emacs lisp to create some 'helper functions'
Ultimately, my helper functions will be more useful that what I have here. I realize that there may be better/ more intuitive ways to accomplish the same thing (please post) but...
Started by Kelly McDonald on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This does what you want:
(defmacro deftext (functionname texttoinsert) (let ((funsymbol (intern (concat "text-... .
It's been years, but I think you're probably missing an fset to define the function; see the docs if you are wanting it a compile time too .
|
|
I want to create a C macro that creates a function with a name based on the line number. I thought I could do something like (the real function would have statements within the braces):
#define UNIQUE static void Unique_##__LINE__(void) {}
Which I hoped...
Started by DD on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The problem is that when you have a macro replacement, the preprocessor will only expand the macros recursively if neither__ macro, which expands to a new integer....
I think you can get this to work with indirect macro expansion .
|
|
I am pasting a table into Excel from SAS where the number of rows spanned by the cell in the first column is variable. That is to say sometimes the first column is 3 merged cells, sometimes it is 6, etc. I would like to run a macro that changes the height...
Started by Steven Noble on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Of the original merged cells at address A1:A2 , it actually has to create a new set up merged cells write a macro that, when executed, popped up an input box that asked the number of cells high select Tools -> Macro -> Record....
|
