Results 1 to 11 of 11

Can't save book with new macro

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2012
    Location
    Dayton, OH
    MS-Off Ver
    Excel 2010
    Posts
    4

    Can't save book with new macro

    I am trying to get a VBA Macro to work properly in Excel 2010. I am not getting any error indications but it won't save.
    Below is the code:
    [code]
    Private Function FishWeight()

    End Function

    Dim W As Integer

    If C3 = ("LMB") Then W = E3 ^ 2 * F3 / 1200
    Else
    If C3 = ("SMB") Then W = E3 ^ 2 * F3 / 1200
    If C3 = ("Rainbow") Then W = E3 * F3 ^ 2 / 800
    If C3 = ("Brown") Then W = E3 * F3 ^ 2 / 800
    If C3 = ("Saugeye") Then W = E3 ^ 3 / 2700
    If C3 = ("Walleye") Then W = E3 ^ 3 / 2700
    If C3 = ("Muskie") Then W = E3 ^ 3 / 3500
    If C3 = ("Northern") Then W = E3 ^ 3 / 3500

    End If
    [code]
    Last edited by Gulfvet91; 03-07-2012 at 08:23 PM. Reason: Bad Title

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