For example, I want to Insert a column to the Left Of column A first.
Next I want to take the data from Column B and do a =left on the first part and a =Mid on the second part (because the data is separated by a "/"; Part number on the left and description on the right.)
I was trying to do it like this:
Sub Inventory_Setup()
Worksheets(1).Range("a7:4000").Value = "=LEFT(B7,FIND(" / ",B7)-2)"
But I get a "Type Mismatch" error.
Any thoughts?
Next I want to take the data from Column B and do a =left on the first part and a =Mid on the second part (because the data is separated by a "/"; Part number on the left and description on the right.)
I was trying to do it like this:
Sub Inventory_Setup()
Worksheets(1).Range("a7:4000").Value = "=LEFT(B7,FIND(" / ",B7)-2)"
But I get a "Type Mismatch" error.
Any thoughts?
Last edited: