+ Reply to Thread
Results 1 to 2 of 2

using application.WorkSheetFunction. in code

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    using application.WorkSheetFunction. in code

    The procedure below is intended to give a range name to a selected area of a newly created sheet.
    It gives an error at the line marked ******
    Please Login or Register  to view this content.
    Can anyone help me by sorting out the syntax ?
    John
    Last edited by j_Southern; 06-21-2017 at 07:00 AM.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: using application.WorkSheetFunction. in code

    You are missing a colon
    Please Login or Register  to view this content.
    If you are pleased with a member's answer then use the Star icon to rate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Application.WorksheetFunction vs Application.NormDist
    By Boo123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2014, 06:33 PM
  2. Application.WorksheetFunction.VLookup
    By Perfexia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2014, 10:49 AM
  3. Application, WorksheetFunction or both?
    By Benni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2012, 08:59 PM
  4. Application.WorksheetFunction
    By roger09 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2011, 09:07 AM
  5. Application.WorksheetFunction.WorkDay
    By yuryyuryyury in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2007, 03:51 PM
  6. [SOLVED] application.worksheetfunction
    By Ozgur Pars in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2006, 03:15 AM
  7. Application.WorksheetFunction problem
    By Gary''s Student in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-18-2005, 03:05 PM

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