Solved: when tab characters are in variable i have a problem

[saban]

How can I paste this variable into cell, but each tab delimited entry should go into separate cell


luka ="NONE NONE __ ____ _____ __ "
ActiveCell = luka 'this will put all the entries in one cell even if tabs are between entries

The angry smiles are squares which suppose to represent tab characters, but when you put it into active cell those tabs are not considered as tabs copy and paste into cell would work OK

[Bob Phillips]

[vba]

aryluka = Split(luka, vbTab)
ActiveCell.Resize(, UBound(aryluka) - LBound(aryluka) + 1) = aryluka
[/vba]

[saban]

Man unbelivable this worked great thnx

[Bob Phillips]

Unbelievable? Why? It is nothing more than I was saying in your previous post.