Results 1 to 6 of 6

Thread: Convert Excel Formulas That Contain Specific Function In To Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-27-2013, 07:46 PM #2
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    I thought you knew :

    Code:
    Sub M_snb()
    With Sheets("sheet1").Cells.SpecialCells(-4123)
        .Value = .Value
    End With
End Sub




    https://www.youtube.com/watch?v=vXyMScSbhk4
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgynOSp1dleo-Z8L_QN4AaABAg.9jJLDC1Z6L-9k68CuL4aTY
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwV5N_ulFXYMNbyQG54AaABAg. 9itCkoVN4w79itOVYVvEwQ
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg. 9isY3Ezhx4j9itQLuif26T
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg. 9irSL7x4Moh9itTRqL7dQh
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg. 9iraombnLDb9itV80HDpXc
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg. 9is0FSoF2Wi9itWKEvGSSq
    Last edited by DocAElstein; 07-09-2023 at 07:37 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. TO convert Excel entire workbook in csv format
    By pritee in forum Excel Help
    Replies: 11
    Last Post: 08-16-2013, 11:28 AM
  3. Copy Row To Another Sheet Depending On Existence Of Specific Value In Specific Column
    By peter renton in forum Excel Help
    Replies: 8
    Last Post: 07-01-2013, 03:52 PM
  4. Learning To Write Excel Formulas And Functions
    By venkat1926 in forum Excel Help
    Replies: 0
    Last Post: 05-19-2013, 09:30 AM
  5. convert/export excel 2007 chart to powerpoint editable chart
    By pushkar_jethi in forum Excel Help
    Replies: 1
    Last Post: 05-20-2012, 12:23 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
  •  

Forum Rules