+ Reply to Thread
Results 1 to 2 of 2

line of visual basic to replace NA with "-" on sheets

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    line of visual basic to replace NA with "-" on sheets

    Hey anyone have a line of code I can throw into my macro to replace NA's with - in my Excel sheets?

    Much appreciated

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: line of visual basic to replace NA with "-" on sheets

    Is it limited to a certain column or row? Or literally accross the ENTIRE worksheet?


    e/ This will do an entire sheet but it may be slower than reducing the scope just to the areas you want effected.

    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

+ 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] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. [SOLVED] "Microsoft Visual Basic runtime error '424' object required".
    By SharonG. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-04-2006, 08:40 PM
  3. [SOLVED] Visual basic unlock "SORT" function in an EXCEL spreadsheet
    By Jetty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2005, 03:05 PM
  4. [SOLVED] Activate check "Trust access to Visual Basic " in Excel
    By Pablo via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-23-2005, 12:05 PM
  5. I Visual Basic Error "File Not Found" when Excel opens
    By Brent E in forum Excel General
    Replies: 1
    Last Post: 03-02-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1