Search Results

Search found 1127 results on 46 pages for 'macro'.

Page 28/46 | < Previous Page | 24 25 26 27 28 29 30 31 32 33 34 35  | Next Page >

• 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

• 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

• 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

• 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

• Visual Studio 2008 MyMacros nowhere to be found

  - by bo gusman

  I'd like to assign a keyboard shortcut to a macro I've written but Tools/Options/Keyboard does not show MyMacros. I reset settings as specified here but that did not solve the problem. Any other ideas?

  Read the article

• vba: get location of current worksheet

  - by every_answer_gets_a_point

  i wrote a macro that is an add=in it needs to figure out the location of the current worksheet on which it is being executed. how do i do this? i need the file location (directory)

  Read the article

• Win32 C++ Import path based on OS?

  - by Zenox

  I'm working with some legacy code that has an import like so: #import "C:\Program Files\Common Files\System\ado\msado15.dll" rename("EOF", "EndOfFile") The problem is, on a x64 machine the path for this import is in the 'Program Files (x86)' directory. Is there a preprocessor macro I can wrap around this to make it work on either? Edit: I think I found it. _M_X64, but im not 100% sure if this is correct.

  Read the article

• What is your most useful C/C++ snippet?

  - by maddizzyro

  Hello all, It seems that every project has an "util" module with various code snippets used throughout other files and which don't fit any particular pattern. I want to improve my "util" library, so please post here the most useful class / function / macro that you use in all your C/C++ projects. Please keep the entries small (under 100 lines) and give only one example per post. Thank you.

  Read the article

• Count if with two criteria excel vba

  - by Manasa J

  can some one help me create a macro for the following Data.The values in GradeA,GradeB etc.. columns need to be populated by checking sheet1 ColumnB(Student Name) and columnH(Grade).I need both row wise and Column wise total. Student GradeA GradeB GradeC GradeD GradeE GrandTotal Std1 1 0 2 0 0 3 Std2 0 0 0 1 1 2 Std3 1 0 1 0 0 2 Std4 0 2 0 3 0 5 Std5 0 1 2 1 0 4 Std6 1 0 2 0 2 5 Grnd 3 3 7 5 3 21

  Read the article

• Doubt in Conditional inclusion

  - by Philando Gullible

  This is actually extracted from my module (Pre-processor in C) The conditional expression could contain any C operator except for the assignment operators,increment, and decrement operators. I am not sure if I am getting this statement or not since I tried using this and it worked.Also for other manipulation a probable work around would be to simply declare macro or function inside the conditional expression,something like this to be precise. Also I don't understand what is the rationale behind this rule. Could somebody explain? Thanks

  Read the article

• How can I convert Excel VBA to Google spreadsheets Javascript API?

  - by Bearjcc

  I have recorded a macro in Excel, but I want to run this code in Google spreadsheets. I do not know how to program in either code. How do I convert them? I tried an online VB to Javascript converter, but this does not work with VBA.

  Read the article

< Previous Page | 24 25 26 27 28 29 30 31 32 33 34 35  | Next Page >