PDA

View Full Version : Copy and Offset??



SuperGames
04-08-2008, 03:35 AM
Hey guys, newbie here in trying to use VBS in excel..
I am currently using excel 2007 and am needing to copy the text in a cell then pasting it in another cell....

For example I need the text in cell E3 to go to D4 and E5 to D6 and E7 to D8, i need this to go all the way down to E3893 to D3894. Any help that you guys would be able to supply would be great... Thanks for your help it is greatly appreciated...

tstav
04-08-2008, 05:51 AM
Just to get you started, in the VBE Editor, write the word 'Range' (without the single quotes) and hit F1 to get to Help. There's a wealth of information there on ranges. How to select ranges, how to put values to ranges and lots of interesting stuff...
Then you can also check the For...Next loop.
Welcome to this forum