If you want to copy and paste values into TM1 DBRW cells then historically you needed to use SPF (Beachware).
In recent versions of TM1 you are able to copy and paste a single value into a DBRW cell but not a range of cells.
Ben Hill recently posted his vba module that replicates the SPF functionality and I can vouch for its use having used it myself for a good while now.
Check out his download from the TM1 forum:
http://forums.applix.com/forum/tm.asp?m=12606
