LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JTF JTF is offline
external usenet poster
 
Posts: 8
Default Using VBA to copy range of cells

HI all

I need to copy and paste a range of cells from one worksheet to
another. The first cell to be copied will always be A3. The last cell
will vary depending on how many rows of data are entered. The last
entry, however will always be in column S - only the row will vary.

I've tried a number of things, to no avail...can anyone help? Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? excelnovice Excel Worksheet Functions 2 September 25th 05 12:38 AM
Copy Range of Cells in Same Row Moe Excel Discussion (Misc queries) 1 August 4th 05 06:47 PM
Copy cells into range of cells until cell change mdeanda Excel Worksheet Functions 1 April 22nd 05 08:41 PM
copy range of cells using VB Stuart[_18_] Excel Programming 3 October 13th 04 06:51 PM
Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement Kevin Excel Programming 7 October 5th 04 08:11 PM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"