Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi to all
I have been using CopyEditGo ToSpecialVisible Cells Only, to copy filtered data and has worked fine. Now I am getting a message that says.... Office cannot create or use the data range reference because it is too complex... Use data that can be selected in one contiguous rectangle. Use data from the same sheet. The information on this sheet is the same as in other sheets that I have successfully used ths feature-----Same data different months and the data set is smaller than others. I have checked all sheets and the only range selected is only that that I wan to copy. Any ideas? Thanks Melissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Visible Cells Only | Excel Discussion (Misc queries) | |||
Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY | Excel Worksheet Functions | |||
Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel |