Results 1 to 10 of 12

Thread: VBA intersect function for rows and column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    I cant find those named ranges either, and in fact there is no sheet with the name "cost" , so I expect you gave me the wrong file.... or my ignorance in UserForms is showing up, because I still cant see how to get at that macro...
    The file has a worksheet with the name Form, but there are two UserForms, UserForm2 and UserForm3

    I appologise if it is down to my ignorance and lack of experience with such files.
    I know VBA quite well
    I do have some Userforms of my own and I know how to get at all the coding behind them, but I still can't find your
    Private Sub txtdelta_AfterUpdate()

    I cant see anything like your last screenshots anywhere in either the worksheets or in the VB Editor of the file ylou have given.... ( The file I have from you has the name Part tracker test2.xlsm )




    According to my ( limited ) knowledge of VBA if I have a code line like this
    ThisWorkbook.Sheets("Cost")
    then I must have a worksheet with a tab name of "Cost" or else that code line will error

    I think also, that I must see in the Names manager the named ranges of "vrech and "col" or else
    Range("vrech")
    and
    Range("col")
    will error.

    But once again, maybe in my ignorance, I am missing something obvious....
    Last edited by DocAElstein; 07-16-2020 at 04:27 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!

Similar Threads

  1. Transpose rows to column and join table
    By Agoyman in forum Excel Help
    Replies: 1
    Last Post: 04-23-2019, 09:56 AM
  2. Replies: 9
    Last Post: 02-01-2017, 06:04 PM
  3. Function Code for getting Column Letter from Column Number
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-23-2014, 02:27 AM
  4. VBA To Delete Rows Based On Value Criteria In A Column
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 08-15-2013, 12:45 PM
  5. Delete unwanted rows & column
    By sanjeevi888 in forum Excel Help
    Replies: 1
    Last Post: 09-30-2012, 08:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •