Results 1 to 22 of 22

Handy One Liners

Threaded View

  1. #1
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    280

    Handy One Liners

    Below are the ones I had handy; does any one else have any others to add to the list?

    Public Sub UnWrapText(): Selection.WrapText = False: End Sub
    Public Sub removeAllLinks(): ActiveSheet.Cells.Hyperlinks.Delete: End Sub
    Public Function DAdd(S As String, N As Long, D As Date) As Date: DAdd = DateAdd(S, N, D): End Function
    Public Function IsFunction(ref As Range) As Boolean: IsFunction = (Left(ref.Cells.Formula, 1) = "="): End Function
    Last edited by Gregor y; 09-11-2012 at 04:08 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1