May 8th, 2013, 02:34 PM
VBA Excel 2007 Application.WorksheetFunction.Match help...
Good day everyone,
I hope i'm in the right place for VB Excel questions.
I have difficulty finding an answer to my problem. I have a workbook set up for the type of job I’m doing. My codes are mostly mine own and help from others…including multiple website with excel help.
I have hit a wall with all the information passing through I am just lost when it comes to complex coding.
I have a sub Test that includes an MsgBox Application.WorksheetFunction.Match code.
I can’t upload my workbook as there is way too much information.
I have 7 sheets set up, one of them is for my normal control (Hidden sheet) and I have a “Archives” sheet that is also hidden for data and code purpose.
So 5 sheet with a flow, meaning that “The user” will start from sheet1 and work his way to sheet 2 and so on. It is possible to go on any 5 sheets. Depending on what the user is working on. But mainly, it goes from one sheet to the other.
The process is kind of too big to explain on here but I am new, so just wondering what kind of info will be required.
This is kind of what I’m looking for…
The workbook is based on ActiveCell.row method and also Application.WorksheetFunction.Match. Every time you will select a row or a cell and click on the command button “Complete” it will look up in sheet5 and match column A to find the exact same info from Sheet3.
I need to incorporate the following code in my sheet3
So that each time I make a transfer it will delete the /A from my Evaluation but also look in my sheet5 then delete the /A then do the initial Transfer.
For Each Cell In ActiveCell
If Cell.Value Like "*[!0-9]/[A-Z]" Then
Cell.Value = Left(Cell.Value, Len(Cell.Value) - 2)
I would love to insert my workbook for explanation but unfortunately that will not be possible… Posting codes is not an issue.
Click Here to Expand Forum to Full Width