Search:

Type: Posts; User: CatLadee; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: VBA Will Not Accept Vlookup Formula that Works in Sheet

    Thanks a bunch, Joe! I appreciate your help!
  2. VBA Will Not Accept Vlookup Formula that Works in Sheet

    Any ideas why this formula won't work in VBA but will in the worksheet? The responses tab exists. How should it be updated? THANK YOU!


    ActiveCell =...
  3. Re: VBA Count of Range of Numbers (ie, 0-14) in a Column

    This works perfectly! Thank you so much!
  4. VBA Count of Range of Numbers (ie, 0-14) in a Column

    Please help me update the code below so that the counts work on the ranges of numbers (arrows below) Thanks!


    Sub Metrics()

    Dim ws As Worksheet
    Set ws = Worksheets("Master")
    ''
    Total =...
  5. Re-Purposed Code - ActiveX Cannot Create Object help

    I am re-using code that I had used in the past sucessfully. The purpose is to break a spreadsheet intonumerous files based on the value in column A. I am getting the error message “RunTime Error 429...
  6. Re: VBA: Loop through files in a folder and perform vlookup on two columns in each file to pull in data to a master file

    Hi mumps! Thanks a bunch for your help. I just can't get a hang of the loops for the life of me.

    Here are some answers to your questions:
    1 - If the folder will always be the same, it's path can...
  7. VBA: Loop through files in a folder and perform vlookup on two columns in each file to pull in data to a master file

    Hi all,

    Appreciate your help in advance. I have this code and it's purpose is to loop through files in a folder to open them up. From there, a master worksheet will vlookup values from two columns...
  8. Re: Trouble with Counter to Increment Through an Array - What gives?

    Thanks! Your reply got me thinking along and right track and the below worked. All the best to you!


    With Worksheets("Brackets").Range("Anchor_R1") Set rng = Range(.Offset(1, 9),...
  9. Trouble with Counter to Increment Through an Array - What gives?

    Can one of you smart people please give me a hint about why I am unable to increment through one range to move it to another location with my current code? The current counter just gives the last...
  10. Replies
    3
    Views
    193

    Re: Nested Loop Not Populating Down the Rows

    Thanks, Rick! I added an r loop that fixed part of the issue but it's still not clicking.

    This is supposed to pull a string of text from a CSV file with a short list of items and compare them in...
  11. Replies
    3
    Views
    193

    Re: Nested Loop Not Populating Down the Rows

    I've changed it to this - same problem :(


    r = 1
    With Range("Output_Tbl")
    For intOuter = r To intOptions - r '1 to 3
    For intInner = intOuter + r To intOptions
    ...
  12. Replies
    3
    Views
    193

    Nested Loop Not Populating Down the Rows

    Hi all,

    Any ideas why this nested loop is staying on just one row and not pulling down? Thanks in advance - CatLadee



    r = 1
    For intOuter = 1 To intOptions - 1

    For intInner = intOuter + 1...
  13. Re: VBA Count Number of Words in a String with 5+ Characters

    Yes I do! I appreciate your help!
  14. Re: VBA Count Number of Words in a String with 5+ Characters

    Worked perfectly - thank you very much!:)
  15. Re: VBA Count Number of Words in a String with 5+ Characters

    Thanks. I am familiar with all the concepts mentioned on a very beginner level. This is my 5th week in a VBA class for school.

    This is where I am now - The top codes seems to be counting the words...
  16. VBA Count Number of Words in a String with 5+ Characters

    Hi friends,

    I am not sure how to answer this question for a VBA class i'm taking. How would I count only words with 5+ letters? Thank you! CatLadee :confused:



    msg = "Total words: " &...
  17. Re: VBA Vlookup using existing variable as cell reference instead of static cell reference

    I figured it out - .Offset(i, 2).Formula = "=VLOOKUP(" & nTeam1 & ",Data!$A$1:$M$21,2,false)"
    Disregard - thanks :)
  18. VBA Vlookup using existing variable as cell reference instead of static cell reference

    Hi smart people,

    Any ideas on how I can replace a static cell reference in a vlookup with a variable so that I can get this to work in a loop?

    .Offset(1, 2).Formula =...
  19. Replies
    6
    Views
    231

    Re: Replace Error String with " "

    That worked :) Previously I had the whole string in there and it didn't work. I wasn't sure how to integrate the InStr. Thanks so much - you've brightened my day! Cat Ladee
  20. Replies
    6
    Views
    231

    Re: Replace Error String with " "

    I mean that it was returning 200 - OK, 302 - Moved Temporarily, etc and I'm looking to make it an discrepancy report - so to show sites that you can't access. Maybe "error code" is the wrong...
  21. Replies
    6
    Views
    231

    Re: Replace Error String with " "

    For "An error occurred in the secure channel support" or a derivation of that - maybe "secure channel support"? There's no error code that's close to it that could possibly get pulled in mistakenly -...
  22. Replies
    6
    Views
    231

    Replace Error String with " "

    Hi friends

    Brand new to coding. In a VBA class as we speak so be easy!

    I have pieced together code that checks if a long list of website links that are managed by external parties are still...
  23. Re: Help Updating URL Checking Code to Skip Cells and Add Text if Missing a URL

    Sort of! Not exactly but helpful nonetheless - really appreciate you!
  24. How to List all For Loop variables in a MsgBox?

    Hi all,

    I am just starting my VBA journey and am 4 weeks into a class to learn it. I'm trying to show the entire list of variables in the For Next Loop in a message box, a la:

    1 School...
  25. Help Updating URL Checking Code to Skip Cells and Add Text if Missing a URL

    Hoping for a little help with the updates to this code indicated below. Really appreciate your time and input and sending the most positive karma your way! - The Cat Ladee


    Sub ValidateURLs()

    ...
Results 1 to 25 of 29
Page 1 of 2 1 2