Posted to microsoft.public.excel.programming

Bob Barnes[_3_] Bob Barnes[_3_] is offline

external usenet poster

Posts: 10

Simple Copy & Paste

I'm an Access Programmer using automation to send Access data to Excel

I have seven named Ranges accepting Access data. I want to copy & paste the data (no formulas here)
They will be used to find a true Average of the seven Ranges

My code is..
Sheets("110-210").Select: Range("SOne").Select: Selection.Cop
Sheets("350-450").Select: Range("TOne").Clear: Range("TOne").Selec
ActiveSheet.Past

If fails at "ActiveSheet.Paste" "TOne" has 12 Cells as does "SOne"
Maybe the "Range("TOne").Select" is the problem

TIA - Bo

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Simple Macro - I think... Copy - Paste on Click	Scott Campbell[_2_]	Excel Discussion (Misc queries)	5	November 14th 12 12:52 AM
Line copy - Not just a simple copy paste	Ninerref	Excel Worksheet Functions	3	September 10th 09 11:44 AM
Simple copy paste question	Z[_2_]	Excel Programming	3	February 5th 04 09:03 PM
Help! What's wrong with this simple copy and paste	Richard James[_3_]	Excel Programming	4	November 23rd 03 12:57 AM
Simple copy and paste	Fritz[_2_]	Excel Programming	2	November 22nd 03 01:56 PM

All times are GMT +1. The time now is 04:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us