Search results for query: *

Hi Skip, Thanks for assisting in this. For Each sht In Application.Worksheets 'user selected workbook (wbA) If sht.Name <> "templates" Then 'unused worksheet in user selected workbook If Range("l23,l115,l207") <> True Then 'if...

Hi Skip, I am using the cell references to identify if the equipment on that spread sheet is being incorporated into another cabinet or has it's own. The 1st half works ok. If cells are not true, I copy a range name from the user defined spreadsheet into a work book where I add sheets through...

I hope someone can help me. I have a vba script that combines equipment from multiple excel files. The problem I have is trying to compare 2 files for similar worksheet names. If names are similar then I need to add a worksheet in the new workbook after the matching sheeet. I have attached...

I am not having much success. I have part of it working. so far I have: Set Target = ActiveCell Set a = Range("e12") Set b = Range("f12") Set aa = Range("o29") Set ab = Range("p29") If aa = 3 And Intersect(Target, a) Is Nothing Then Exit Sub Cancel = True...

PH, Join was definately the missing link. Works great. thank you. The user form I'm passing the text to is nothing more than user confirmation for file selection. Once there either ok or cancel will be selected. Since I'm not looking for user entry in the form is there pro/con for text box...

Hi, I have been trying to get the right combinations to pass the user selected files from a file open dialog box to a text box in a user form. I think I have the right dialog to put each file on a separate line, but running the routine either doesn't pass the variable or only passes 1 name...