Tags » Vba

SQL vs VBA code in Access

I have not had much experience writing SQL code, I as taught VBA code in school, but not SQL.  At least in Access it seems to be different but less involved. 58 more words

SQL

Excel VBA, Remove Border

In this article I will explain how you can remove borders from a range of cells. Removing borders is similar to creating borders. All you have to do is set the . 505 more words

Excel

Excel VBA Border Colors

One of the things you probably want to modify when working with borders in VBA for Excel is the border color. Previously I’ve explained about… 652 more words

Excel

Excel VBA, Border Style and Thickness

In this article I will explain how you can modify border thickness and style using VBA for Excel. For more information about creating borders please see  730 more words

Excel

ConBeamU Update

Recently a comment pointed out that if the ConBeam, or ConBeamU, user defined functions were used with a single span then the “Out” argument was ignored, so it was not possible to return support reactions.  29 more words

Excel

Excel VBA, Create Border

In this article I will explain how you can make basic borders using VBA for Excel. Each range of cells can accept up to 8 different  826 more words

Excel

Excel VBA Merge Two Roles

A handy code snippet for merging two rows of data!

Sub Macro1()
   ActiveCell.Offset(1, 0).EntireRow.Copy
   ActiveCell.EntireRow.PasteSpecial Operation:=xlNone, SkipBlanks:=True, Transpose:=False
   Application.CutCopyMode = False
   ActiveCell.Offset(1, 0).EntireRow.Delete (xlShiftUp)
End Sub
… 43 more words
Excel 2010