Results 1 to 7 of 7

Thread: Replace Cell References In Formulas With Their Actual Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-16-2013, 01:16 AM #2
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    There's another property
    Code:
    Sub M_snb()
      For Each it In Sheets("sheet3").Cells(1).Precedents
         x3 = it.Address
      Next
End Sub

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 10-02-2023 at 12:54 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro For Converting Text And Actual Dates From DMY to MYD
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 07-04-2013, 12:37 PM
  2. VBA Using MID Function To Replace Portion Of A String
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 05-30-2013, 08:22 PM
  3. Replace Incorrect Date In Cell To Another Valid Date
    By DARSHANKmandya in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 03-21-2013, 09:27 PM
  4. Date References to save files using VBA Code
    By mrmmickle1 in forum Excel Help
    Replies: 3
    Last Post: 11-28-2012, 05:48 PM
  5. Replace Currency Format From One to Another at One go !! (VBA)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-19-2011, 09:13 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