INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Print Excel Formula to Immediate Window and/or Work with the actual formula

Print Excel Formula to Immediate Window and/or Work with the actual formula

Print Excel Formula to Immediate Window and/or Work with the actual formula

(OP)
I must be going batty, because I could swear I've done this before.

For some Excel changes, I want to use a value in one formula to create something in a different cell via VBA code. But for initial testing, I just want to be able to print the actual formula text to the immediate window.

So this is what I've got so far, and it's giving me the values instead of formula text:

CODE

Sub GetFirstLastNames()
    Dim wb As Workbook
    Dim wsMain As Worksheet
    Dim ws As Worksheet 'for looping through sheets
    Dim x As Integer
    
    Set wb = ActiveWorkbook
    Set wsMain = wb.Worksheets("Complete List")
    
    For x = 3 To wsMain.Range("F3").End(xlDown).Row
         Debug.Print wsMain.Cells(x, 6).Formula & "   " & InStr(1, wsMain.Cells(x, 6).Formula, "!")
    Next x

    Set ws = Nothing
    Set wb = Nothing
End Sub 

Can anyone tell me what I'm forgetting???

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

RE: Print Excel Formula to Immediate Window and/or Work with the actual formula

Hi,

Are you sure that F3 and following contain formulas?

Your code DOES print formulas if the cell contains such.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Print Excel Formula to Immediate Window and/or Work with the actual formula

(OP)
Oh my... oh my.... and.... oh my...

Yep, It's time for me to go back to bed. Formulas were in column G.

Thanks for rescuing my sanity!

blush banghead

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close