Results 1 to 10 of 10

Thread: Extracting the sheet name only (as a string) from a formula to another cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-20-2013, 04:21 PM #7
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    or
    Code:
    Function GetText(frm As Range) As String
    GetText = Split(Replace(Mid(frm.Formula, 2), "'", ""), "!")(0)
End Function
    Code:
    Function GetRow(frm As Range) As Long
    GetRow = frm.row
End Function
    Last edited by snb; 08-20-2013 at 04:24 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Highlighting All the Cells of Active sheet which contains a particular String:
    By littleiitin in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 10-18-2013, 04:19 PM
  2. Extracting Custom Pattern Consisting of Numbers & Text From Alphanumeric String
    By larkspur in forum Excel Help
    Replies: 14
    Last Post: 05-25-2013, 06:55 AM
  3. Copy Sheet name to Cell without Updating the other Sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 1
    Last Post: 02-10-2013, 06:21 PM
  4. require formula help to copy data from sheet to sheet
    By Terry in forum Excel Help
    Replies: 2
    Last Post: 12-26-2012, 08:31 AM
  5. Find Color in the string using formula.
    By LalitPandey87 in forum Excel Help
    Replies: 4
    Last Post: 07-10-2012, 09:16 PM

Tags for this Thread

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