VBA Code issue - ExcelBanter

Posted to microsoft.public.excel.programming

scrabtree23[_3_] scrabtree23[_3_] is offline

external usenet poster

Posts: 55

VBA Code issue

Here is my code:

Sheets("Stepdown2").Columns("P:S").Select
Selection.ClearContents
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="<"

Set rang = Sheets("Stepdown2").AutoFilter.Range
rang.Copy
Sheets("CEU Database").Select
Rows("4:4").Select
Selection.Insert Shift:=xlDown

I get an error at the last line. When I try it manually it says the paste
area and the copy area are not the same size???

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
split post code (zip code) out of cell that includes full address	Concord	Excel Discussion (Misc queries)	4	October 15th 09 06:59 PM
Code to conditional format all black after date specified in code?	wx4usa	Excel Discussion (Misc queries)	3	December 26th 08 07:06 PM
Drop Down/List w/Code and Definition, only code entered when selec	Spiritdancer	Excel Worksheet Functions	2	November 2nd 07 03:57 AM
option buttons run Click code when value is changed via VBA code	neonangel	Excel Programming	5	July 27th 04 08:32 AM
VBA code delete code but ask for password and unlock VBA protection	WashoeJeff	Excel Programming	0	January 27th 04 07:07 AM

All times are GMT +1. The time now is 11:30 AM.

Menu

About Us