Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste error
I am tryng to copy and paste after filter using the below macro. However, it
prompt me an error stating (total no of rows: 30K, after filtered: 15K): "Microsoft Office Excel cannot create or use the data range reference because it is too complex...." Even when I put in the "On error resume next", my range data selection is blank and I copy and paste empty data. *********My macro*********** If .Cells(1, Colcount) = "KEYFIG" Then .Cells(1, 1).AutoFilter Field:=Colcount, Criteria1:="OPT RDP" With .AutoFilter.Range On Error Resume Next Set Filterrg = .Offset(1, 0).Resize(.Rows.Count - 1, 1).SpecialCells(xlCellTypeVisible) Filterrg.Copy End With End If *************************** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Validation List Error | Excel Discussion (Misc queries) | |||
Copy paste formula error | Excel Discussion (Misc queries) | |||
Copy/Paste error | Excel Worksheet Functions | |||
Date copy, Paste error | Excel Discussion (Misc queries) | |||
Copy-Paste sheets - error in the dates | Excel Worksheet Functions |