Thread: VBA Code issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree23[_3_] scrabtree23[_3_] is offline
external usenet poster
 
Posts: 55
Default 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???