| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells and paste to an address given in another cell (VBA Newbie)
Can anyone help with this problem. I am trying write a macro to copy range of cells on one worksheet, then goto an address which i specified in a cell. (This address is dynamic and changes according t the date) The data can then be copied to the new location. I a attaching a bitmap image of my example. Here are my required actions: Go to cell B27-B33 on worksheet "Entry Sheet" Copy cells B27-B33 Go To the address in cell B20 (in this case Data!J29) Paste the copied cell Thanks in anticipation Ro +------------------------------------------------------------------- |Filename: DataCopyExample.doc |Download: http://www.excelforum.com/attachment.php?postid=3928 +------------------------------------------------------------------- -- WightRo ----------------------------------------------------------------------- WightRob's Profile: http://www.excelforum.com/member.php...fo&userid=1379 View this thread: http://www.excelforum.com/showthread.php?threadid=47801 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste Formula-dropping 1st cell address | Excel Discussion (Misc queries) | |||
| Need code to copy and paste based on cell address. | Excel Discussion (Misc queries) | |||
| Copy/Paste Hyperlink Address | Excel Discussion (Misc queries) | |||
| How can I copy/paste a hyperlink address without the link? | Excel Discussion (Misc queries) | |||
| Copy & Paste Hyperlink address into cell | Excel Programming | |||
Threaded Mode
