+ Reply to Thread
Results 1 to 2 of 2

Simple If statement throws an error

  1. 02-01-2011, 10:00 AM #1
    ronanm
    ronanm is offline
    Registered User
    Join Date
    08-30-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    30

    Simple If statement throws an error

    My IF statement returns an error. I am guessing I have an End IF, or Else in the wrong place...


    Please Login or Register  to view this content.
    Thanks

    Ronan
    Reply With QuoteRegister To Reply
  2. 02-01-2011, 10:07 AM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Simple If statement throws an error

    You have no Sheet Object assigned to ws variable.

    Might be worth outlining what you're trying to achieve as I suspect you can condense the code etc...
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1