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
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