copy sheet to another - Xtreme Visual Basic Talk

04-20-2004, 04:34 AM

Kibbs

Freshman

Join Date: Apr 2004

Posts: 29

copy sheet to another

I have a sheet that contains imported data and need to copy it to another sheet complete just copy and paste. However if someone changes the column size an error indicating different shape is received.

I have this code and figure there has to be a better way

Sheets("ImportData").Select
ActiveSheet.Cells.Select
Selection.Copy
Sheets("RawData").Select
ActiveSheet.Paste

I would have imported this directly to the Rawdata sheet however other sheets have formula dependancies.

Thanks

Wayne

04-20-2004, 10:39 AM

Jamirez

Contributor

Join Date: Jan 2004

Location: Sherbrooke/Québec/Canada

Posts: 614

A faster way... You can change Destination Cell with any kind of range...

Code:

Sheets("ImportData").Cells.Copy Sheets("RawData").Cells

__________________
J a m i r e z

There are 10 type of people. Those which understand binary and those which do not understand it.

04-21-2004, 08:48 AM

Kibbs

Freshman

Join Date: Apr 2004

Posts: 29

Great stuff Jamirez, thanks!!

Wayne

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
save as coding	newtovb99	Excel	8	03-30-2004 03:46 PM
Seemingly silly issue, sheet copy	hloos	Excel	7	01-16-2004 03:19 PM
copy a row from one excel sheet to another using vb code	nubee	Excel	2	08-13-2003 09:44 AM
copy date from sheet and rename sheet	gumby	Word, PowerPoint, Outlook, and Other Office Products	2	02-19-2003 12:52 PM
Hekp Importing Excel	JonM	Word, PowerPoint, Outlook, and Other Office Products	2	05-01-2002 09:45 AM