Delimiters

[Bschutz]

Hi I have a spreadsheet to work on and a broken macro I’m trying to reverse engineer the macro into steps for my boss. VBA code says

Split job code to find work order number

Dim WO As Variant, JobCode As Variant, VarDelim As Variant
Dim n As Interger

JobCode = ActiveCell
VarDelim = “,”
WO = Split(JobCode, VarDelim)

n = 2

I am in text to columns, selected delimited but am unsure what to do next?

Any help would be much appreciated!

[FDibbins]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Also, please take a moment to read our rules regarding thread titles

[jolivanes]

It would be oh so nice to have a workbook to work with.
Attach a sanitized copy of your workbook with before and after showing.
It needs to be a representative copy.

[bakerman2]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Bschutz]

I don’t have remote access to the workbook, I have a complete copy of the macro code and he wants me to work it into manual steps, if I upload the entire code would that help?

[jolivanes]

You can explain what needs to happen. Be concise and to the point. Don't leave anything out.
Maybe show some data since you need to separate data by the sound of it.

[Bschutz]

Attachment 618941

This keeps coming up when I reply with the code?

[bakerman2]

Copy-Paste the code in the Quick Reply window. Select all the code and click the # icon just above the Quick Reply window.