PDA

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



saban
09-14-2008, 07:59 AM
How can I paste this variable into cell, but each tab delimited entry should go into separate cell


luka ="NONE :motz2: NONE:motz2: __ :motz2: ____ :motz2: _____ :motz2: __ "
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
09-14-2008, 09:37 AM
aryluka = Split(luka, vbTab)
ActiveCell.Resize(, UBound(aryluka) - LBound(aryluka) + 1) = aryluka

saban
09-14-2008, 03:12 PM
Man unbelivable this worked great thnx :beerchug:

Bob Phillips
09-14-2008, 03:43 PM
Unbelievable? Why? It is nothing more than I was saying in your previous post.