Search Results

Search found 1554 results on 63 pages for 'sas macro'.

Page 38/63 | < Previous Page | 34 35 36 37 38 39 40 41 42 43 44 45  | Next Page >

• Loop through worksheets without using VBA

  - by Antony Carthy

  Hi All, I need to total certain cells based on a condition across all worksheets in the workbook. The pseudocode would be Foreach ws as Worksheet 'total =SUMIF (A2:A5, "search term", B2:B5) Next MsgBox (total) But I don't want to use a macro. Any ideas?

  Read the article

• Generate digital signature using VBA

  - by tputkonen

  I have text cells of arbitrary length in Excel's column A. Using a private key, I want to generate digital signature for data in column A into the cell in column B. I'm looking for a macro implementation for the digital signature algorithm - I don't think one ships with Excel, but is there an addon available? It must be possible to easily verify correctness of the signature in other environments as well.

  Read the article

• C preprocessor: using #if inside #define?

  - by Wxy

  I want to write a macro that spits out code based on the boolean value of its parameter. So say DEF_CONST(true) should be expanded into "const", and DEF_CONST(false) should be expanded into nothing. Clearly the following doesn't work because we can't use another preprocessor inside #defines: #define DEF_CONST(b_const) \ #if (b_const) \ const \ #endif Any idea about how to do it?

  Read the article

• Automate "Attach to Process" in VS2005/2008

  - by lomaxx

  I was wondering if anyone knew of a macro or keyboard shortcut or anything really that would automate Attaching to a Process within visual studio?

  Read the article

• Defining _LIBC in C++ Program

  - by Vaibhav

  Some of the GNU library code can be have enhanced debugging if the flag _LIBC is set. While using -D_LIBC when compiling gives the error message "/usr/include/gnu/stubs.h:7:3: #error Applications may not define the macro _LIBC" So how do you define this variable?

  Read the article

• Automatic creation of method definitions from declarations

  - by heeen

  Is there a tool, macro or plugin that can generate a method or function body automatically from a declaration in a header file? I have tried Intellisense and Refactor! 3.0.5 which both only seem to work with C#.

  Read the article

• how can I make shortcut the menu, Language -> J -> Javascript

  - by sunglim

  I often open .aspx file. I used to do language - j - javascript. every time when I open aspx file it's really annoying I like to make short cut or macro. But I cannot find this menu on Shortcut mapper. How Can I do this?

  Read the article

• VBA: Validate List settings

  - by stanigator

  Sub Macro1() ' ' Macro1 Macro ' ' Worksheets("Drop-down").Select For i = 1 To 10 ActiveSheet.Cells(i, 2).Select With Selection.Validation .Delete ' Error in this line .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:=Range(Worksheets("Misc").Cells(2, i), Worksheets("Misc").Cells(2, i).End) .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With Next i End Sub I'm getting an error in the line below the comment, yet I don't know how to fix it. It would be great to hear some suggestions. Thanks in advance!

  Read the article

• "reduce" or "apply" using logical functions in Clojure

  - by Alex B

  I cannot use logical functions on a range of booleans in Clojure (1.2). Neither of the following works due to logical functions being macros: (reduce and [... sequence of bools ...]) (apply or [... sequence of bools ...]) The error saying that I "can't take value of a macro: #'clojure.core/and". How to apply these logical functions (macros) without writing boilerplate code?

  Read the article

• Excel c# convert cell to percentage

  - by rubentjeuh

  Hello. I need to convert a cell with a double to a precentage. I used a macro in excel and it says: Range("B5").Select Selection.Style = "Percent" When I do this in c#, it doesn't work: Excel.Range procentRange = xlWorksheet.get_Range("A1","A1"); procentRange.Style = "Percent"; Anybody knows how to do this?

  Read the article

• How to know if a cell has an error in the formula in C#

  - by Pascal

  In an Excel formula you can use =ISERR(A1) or =ISERROR(A1) In a VBA macro you can use IsError(sheet.Cells(1, 1)) But using a VSTO Excel Addin project I did not found similar function under the Microsoft.Office.Interop.Excel API. My current workaround is to do this for all the existing error messages.: if (((Range)sheet.Cells[1, 1]).Text == "#N/A" || ...) Is there a better way to do this. I mean built in the API?

  Read the article

• Does anyone have a Notepad++ plugin that will generate UUIDs and insert them.

  - by rathkopf

  I Often need UUIDs inserted into files that I'm editing in Notepad++. Does anyone have a macro or add in that does this. Or an autohotkey script?

  Read the article

• Find a column with specified text and then search rows for zero enries and delete whol reo if zero f

  - by total newbie

  I need a macro to do this please - any know where i can find one? Find a column with specified text and then search rows for zero enries and delete whole row if zero found

  Read the article

• Embed timestamp at Compile Time with C++

  - by theactiveactor

  I want to perform a printf() to display when the currently executing code was last compiled. Does C/C++ provide a macro that gives you that resolves to a timestamp during compilation?

  Read the article

• Under what conditions will you get unresolved external symbol for __declspec(dllimport)?

  - by Mark

  I am converting an application to use .dlls and I'm riddled with linker errors stating unersolved external symbol"__declspec(dllimport) public: void __thiscall Rail::SetNextrail(class Rail *)" There is more gibberish at the end of this error message. Why should this happen and how do you fix it? __declspec(dllimport) is being placed with a macro defined as: #ifdef LUDOAI_EXPORT #define DECLSPECAI __declspec(dllexport) #else #define DECLSPECAI __declspec(dllimport) #endif

  Read the article

• Excel hyperlink

  - by developer

  Hi All, I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in all cells. Is there a way I can create active hyperlinks to all the cells without writing a macro.

  Read the article

• How can I find the number of highlighted chunks of text in an MS Word Document

  - by Majid

  Hi all, I am writing a macro in MS Word which should find all highlighted text in a document and perform some action on each. I am planning a loop to do the search and manipulation part and have no problem with this part of the code. But I don't know how to find how many iterations I'm going to need. Is there a vay to determine the number of highlights in VBA? Many thanks in advance.

  Read the article

• Is there a library / api for reading the contents of a .hlp help file?

  - by boccato

  I have a help file for my program and was asked to add a description of the menus in a toolbar as the user browses them. So I thought I could just use the beginning of the menu's description of the help but just cant find how to access the contents of it. I saw WinHelp has a macro language, so I figured maybe through this, but I couldnt find any references on this around. Anybody now some pointers or examples of hot to do this?

  Read the article

• Prohibiting copy construction and copy assignment in C++

  - by Jack Nock

  To prohibit copy construction and copy assignment, I've seen the boost noncopyable class and in the Google style guide the DISALLOW_COPY_AND_ASSIGN macro. Is there any reason to prefer one of the techniques over the other, or any subtle differences one should be aware of?

  Read the article

• C: what should I use for trace/diagnostic messages in a library?

  - by Cheeso

  In .NET I would use System.Diagnostics.Trace... What would I use in C or C++ ? right now I have a macro defined: diagnostics ON: #define DIAG(A) { printf(A); } debugging off: #define DIAG(A) { if(FALSE) {}} Is there a standard way?

  Read the article

• What is prepare_arch_schedule for?

  - by EpsilonVector

  I'm messing around with Linux kernel 2.4 and function schedule() in sched.c uses the macro prepare_arch_schedule, which appears to be an infinite loop. What is that? And how does it finish?

  Read the article

• How to retrieve values of an enumeration of given string literal

  - by TonyP

  Need to get a value of an enumeration of a given string literal like "xlCenter" (these values are cut and pasted from Excel Macro). I would like to retrieve the actual constant value (int) -4108="xLCenter" via com marshaling is this possible ? if so how ? Ideally I am looking for function like this public int ExcelConstant(string constantName) { ...} Thanks

  Read the article

• How do you construct a symbol in clojure?

  - by Nick Orton

  I want to construct a macro that given a symbol 'foo creates a method called foo*. How do concatinate 'foo and '* ?

  Read the article

• How do I Increase cell value in Excel using VBA? Error: Type mismatch

  - by John

  I'm writing a macro, but because I'm working for first time in vb, I faced problems. My code: Cells (1, 1).Select Dim tempvar As Integer tempvar = Val(Selection.Value) // error Selection.Value = tempvar + 1 What my code should be: Cells(1,1).Value+=1 I get error "type mismatch". How do I accomplish that?

  Read the article

• How to convert an integer to a string in GLib?

  - by Ashwin

  I want to convert an integer value to string in GLib. Is there any macro or function to da that? Or Can i store different data types in the same doubly linked list?

  Read the article

< Previous Page | 34 35 36 37 38 39 40 41 42 43 44 45  | Next Page >