About 788,000 results
Open links in new tab
  1. Does the += operator just not exist in VBA? - Stack Overflow

    VBA is quite different from VB.net - VBA isn't so strict with type but then again VB.net isn't as strict as c#. I like them all - VBA seems limited but if you are playing with Excel then VBA is part of …

  2. What is the equivalent of "!=" in Excel VBA? - Stack Overflow

    The problem is that != does not work as a function in excel vba. I want to be able to use If strTest != "" Then instead of If strTest = "" Then Is there another approach to do this besides !=? ...

  3. Excel VBA Loop on columns - Stack Overflow

    Dec 21, 2012 · Excel VBA Loop on columns Asked 12 years, 10 months ago Modified 4 years, 11 months ago Viewed 283k times

  4. excel - Use of symbol # (hash) in VBA Macro - Stack Overflow

    Jun 5, 2012 · What is the meaning of the use of the # symbol in Excel VBA? It is used like this: a = b /100# I don't understand the significance of # after the 100?

  5. excel - Declare and use range in vba - Stack Overflow

    Dec 10, 2014 · I am quite new to VBA, Today developing a macro I noticed something funny. Using Range like this is working : Dim rg As Range Set rg = ActiveSheet.Range("A1:B2") …

  6. VBA to copy a file from one directory to another - Stack Overflow

    I have an access file that I regularly need to copy to another directory, replacing the last version. I would like to use an Excel macro to achieve this, and would also like to rename the file in the

  7. How Do I Convert an Integer to a String in Excel VBA?

    Jul 21, 2012 · How do I convert the integer value "45" into the string value "45" in Excel VBA?

  8. vba - How to add default signature in Outlook - Stack Overflow

    54 I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding so far, but I'm new to Outlook. After creating the mailitem object, how do I …

  9. vba - Removing All Spaces in String - Stack Overflow

    Feb 18, 2017 · I created a macro for removing all whitespace in a string, specifically an email address. However it only removes about 95% of the whitespace, and leaves a few. My code: …

  10. vba - Continue For loop - Stack Overflow

    Heck, I wrote so much VBA code at one time (before CS and IT were a thang) that I couldn't even recognise that I was the one who wrote some of it. Appreciate the intellectual exercise 25 …