VBA Excel – Insert row below with same format including borders and frames
The easiest option is to make use of the Excel copy/paste.
vba
What exactly is the function of Application.CutCopyMode property in Excel
By referring this(http://www.excelforum.com/excel-programming-vba-macros/867665-application-cutcopymode-false.html) link the answer is as below: Application.CutCopyMode=False is seen in macro recorder-generated code when you do a copy/cut cells and paste . The macro recorder does the copy/cut and paste in separate statements and uses the clipboard as an intermediate buffer. I think Application.CutCopyMode = False clears the clipboard. Without that line you will get … Read more
What is the function of FormulaR1C1?
FormulaR1C1 has the same behavior as Formula, only using R1C1 style annotation, instead of A1 annotation. In A1 annotation you would use: In R1C1 you would use: It doesn’t act upon row 1 column 1, it acts upon the targeted cell or range. Column 1 is the same as column A, so R4C1 is the … Read more
“Sub or Function not defined” when trying to run a VBA script in Outlook
I solved the problem by following the instructions on msdn.microsoft.com more closely. There, it is stated that one must create the new macro by selecting Developer -> Macros, typing a new macro name, and clicking “Create”. Creating the macro in this way, I was able to run it (see message box below).
Does VBA have Dictionary Structure?
Yes. Set a reference to MS Scripting runtime (‘Microsoft Scripting Runtime’). As per @regjo’s comment, go to Tools->References and tick the box for ‘Microsoft Scripting Runtime’. Create a dictionary instance using the code below: or Example of use: Don’t forget to set the dictionary to Nothing when you have finished using it.
VBScript to open a dialog to select a filepath
There is another solution I found interesting from MS TechNet less customization but gets what you wanted to achieve. This returns the full path of the selected file.
Check if a string contains another string
Use the Instr function will return 15 in pos If not found it will return 0 If you need to find the comma with an excel formula you can use the =FIND(“,”;A1) function. Notice that if you want to use Instr to find the position of a string case-insensitive use the third parameter of Instr and give it the const vbTextCompare (or just … Read more
What does <> mean?
Yes, it means “not equal”, either less than or greater than. e.g can be read as if x is less than y or x is greater than y then The logical outcome being “If x is anything except equal to y”