+ Reply to Thread
Results 1 to 5 of 5

.Formula not working. I bet this is simple!

  1. 01-06-2015, 12:18 PM #1
    gedwards913
    gedwards913 is offline
    Registered User
    Join Date
    05-06-2014
    Location
    Morrisville, NC
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    43

    Exclamation .Formula not working. I bet this is simple!

    I am having an error with the code below to insert a formula into Range A4:A(whatever last row is). Anyquick fixes? My formula is:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-06-2015, 12:20 PM #2
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: .Formula not working. I bet this is simple!

    You need to double every " mark in the formula:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  3. 01-06-2015, 12:22 PM #3
    gedwards913
    gedwards913 is offline
    Registered User
    Join Date
    05-06-2014
    Location
    Morrisville, NC
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    43

    Re: .Formula not working. I bet this is simple!

    Awesome!!! Thanks a million. Works like a dream. I appreciate your time with this!
    Reply With QuoteRegister To Reply
  4. 01-06-2015, 12:23 PM #4
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: .Formula not working. I bet this is simple!

    Glad to help.
    Reply With QuoteRegister To Reply
  5. 01-06-2015, 12:24 PM #5
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: .Formula not working. I bet this is simple!

    Maybe:

    Please Login or Register  to view this content.
    You need double "
    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)

Similar Threads

  1. [SOLVED] Simple v look up formula is not working
    By ryan4646 in forum Excel General
    Replies: 11
    Last Post: 11-30-2013, 02:09 AM
  2. Simple Formula Addition Not working
    By kwright90 in forum Excel General
    Replies: 26
    Last Post: 03-31-2009, 09:10 AM
  3. [SOLVED] Simple formula NOT working :(
    By Danny Lewis in forum Excel General
    Replies: 3
    Last Post: 08-01-2006, 05:40 AM
  4. [SOLVED] simple formula not working
    By Charles Shapiro in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2006, 03:29 AM
  5. Simple Formula not working?
    By GETGO in forum Excel General
    Replies: 2
    Last Post: 01-06-2005, 08:50 AM

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